[mulmen]

I don’t understand how changing the order of the clauses makes a query easier to type.

[spullara]

If you have auto-complete it can see what table you are using and complete the column names. Starting with SELECT it could be any column in the database.

[mulmen]

Huh. I have been doing this for like 15 years and never have a problem. Text editors like Sublime Text suggest names based on the content of the file. SQL Developer, SQLWorkbench, and DataGrip all seem to handle it just fine.

[spullara]

It will suggest names that aren't in the table you are going to query unless it is psychic.

[mulmen]

It is psychic in the sense that it makes educated guesses based on previous entries and the current database and schema. This is the same kind of educated guess it would make with a table name.

[nhinck2]

I see this complaint stated over and over again, how hard is it really to type SELECT * FROM x a and then go back?

[spullara]

Is there any downside at all to putting FROM first?

[mulmen]

Disrupting decades of inertia to placate a small humber of unskilled novices.