4 ms·
it seems like any SQL parser could let you put FROM first and solve a lot of the annoyances of SQL
by spullara 3y ago
it seems like any SQL parser could let you put FROM first and solve a lot of the annoyances of SQL
- mulmen 3y agoThe stiff syntax is a feature. The infamous 1000 line sales report query is already a bear to maintain. If you get a clever developer reordering syntax it will only be worse.
- strokirk 3y agoIt’s certainly not a feature. A lot of important SQL usage is ad-hoc queries, and they are more annoying to type than they should be.
- mulmen 3y agoI don’t understand how changing the order of the clauses makes a query easier to type.
- spullara 3y agoIf 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.
- nhinck2 3y agoI see this complaint stated over and over again, how hard is it really to type SELECT * FROM x a and then go back?
- mulmen 3y agoHuh. 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 3y agoIt will suggest names that aren't in the table you are going to query unless it is psychic.
- mulmen 3y agoIt 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.