SQLite Forum

Ability to: SELECT * EXCEPT(some,columns)
Login
I disagree.

Any query regardless of how it is formed (sub-queries, joins, whatever) has a stable column output when doing `SELECT *`.

Do you get the columns in different order each time the query is run (without changes)?  I don't think so.

Once the query is finalized you know the order of the output and the respective names (even generated ones, e.g., expressions that you can always alias to simpler ones).

agp