Answer
You can still use a table alias, just not directly in the main view/select field itself — it works fine inside a sub-query, such as in the WHERE condition. If you need to reference specific columns using an alias (for example, to disambiguate them when the same view is joined to itself or another view with overlapping column names), structure that reference as part of a sub-query condition rather than trying to alias the top-level view definition directly.