Re:Literate SQL
by lisper on Sunday June 25, 2017 @08:10PM
(#14632983)
Why not just reverse the SELECT and FROM clauses?
or even better
Then the compound version looks like:
or
Actually, putting the WHERE before the SELECT makes even more sense.
[ Parent
| on HN ]
Because that's invalid SQL?
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.