SQLite Forum

Table aliases on parenthesized results of JOINS and set operations (UNION etc.) -- feature or chance?
Login
That this behavior is documented can be seen in [the railroad chart for ["table or subquery"](https://sqlite.org/syntax/table-or-subquery.html). So, rely on it and be happy.