Comment by quocanh
4 years ago
I agree that the columns of the results should be more obvious. But I am a proponent of "from should be first". I have never written a SQL query without thinking about the contents of a table or its relations. If it was my way, I would describe where the data I'm pulling from, then describe any filters/joins, then describe the columns that I'm interested in (last).
You've never authored a SQL query that does things like check special functions that don't exist in a table?
For example:
Seems easy enough to work around with a magic table name in this hypothetical future reworked dialect of SQL?
or