3 ms·
Does anybody else like putting from first? I find it makes the auto complete sooo much better and easier to read.
by nerdbaggy 6y ago
Does anybody else like putting from first? I find it makes the auto complete sooo much better and easier to read.
- chubot 6y agoI like it, but sqlite doesn't seem to accept it? At least not in the version on my Ubuntu machine. Is putting from first standard SQL?
- deleted 6y ago[deleted]
- SigmundA 6y agoXquery and Linq both use FLWOR like syntax which puts the "FROM" first and helps auto complete, wish SQL had ordered things this way: https://en.wikipedia.org/wiki/FLWOR https://en.wikipedia.org/wiki/FLWOR SELECT first_name FROM person WHERE first_name LIKE 'john' becomes: FROM person WHERE first_name LIKE 'john' SELECT first_name SQL reads more English like while from first is more Yoda speak but the auto-complete is worth more to me.
- 7952 6y agoI think it would be easier to order things in terms of when they are executed. And perhaps it would be easier to teach SQL if the different parts where more obviously separate. As the different parts are actually distinct and don't really cross over. But to a newbie would seem procedural when it's not.