zlacker

>>heyden+(OP)
Is there research on what is easier to read when you are sifting through many queries?

I like the syntax for reading what the statement expects to output first, even though I agree that I don’t write them select first. I feel like this might be optimizing the wrong thing.

Although the example is nice, it does not show 20 tables joined first, which will really muddle it.

>>rileym+jV9
The select list is meaningless without everything that follows. Knowing that a query selects "id, "date" tells you nothing without knowing the table, the search criteria, etc.

>>beart+C0a
I really wish SQL used "RETURN" instead of "SELECT" (like in XQuery):

1. Calling it "RETURN" makes the fact of its later order of execution (relative to FROM etc) less surprising.

2. "RETURN RAND()" just reads more naturally than "SELECT RAND()". After all, we're not really "selecting" anything here, are we?

3. Would also eliminate any confusion with the selection operation in relational algebra.