[nerdbaggy]

Does anybody else like putting from first? I find it makes the auto complete sooo much better and easier to read.

[SigmundA]

Xquery 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

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.

[chubot]

I 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?

[7952]

I 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.