News for hackers. Stuff that matters.
Re:Literate SQL by lisper on Sunday June 25, 2017 @08:10PM (#14632983)
Why not just reverse the SELECT and FROM clauses?

    FROM table1, table2
    SELECT col1, col2
    WHERE ...
or even better

    FROM table1 JOIN table2 ON condition ...
    SELECT ...
    WHERE [additional join conditions]
    HAVING [filter conditions]
Then the compound version looks like:

    FROM (
      FROM tables...
      SELECT ...
      WHERE
    ) SELECT...
    WHERE ...
or

    FROM (
      FROM tables ...
      SELECT ...
    ) JOIN [whatever]
    SELECT ...
    WHERE ...
Actually, putting the WHERE before the SELECT makes even more sense.
Re:Literate SQL by kierenj on Monday June 26, 2017 @07:52AM (#14635993)
Because that's invalid SQL?
Re:Literate SQL by lisper on Monday June 26, 2017 @11:31AM (#14637567)
So was the WITH clause until someone decided it should be valid and added it.

Every improvement to every language ever started out with someone saying, "Hey, here's an idea..." And none of those ideas were ever "valid X" at the time they were proposed.