News for hackers. Stuff that matters.

A comment on Select * from cloud. Parent comment

Re:Select * from cloud by emmelaich on Friday September 30, 2022 @08:04PM (#33042310)
I hope that those two syntaxes could be unified in some future version.

Also, surely allowing FROM and SELECT clauses to be swapped in order shouldn't stress out any parser too much.

[ Parent | on HN ]
Re:Select * from cloud by wruza on Saturday October 01, 2022 @07:07AM (#33045662)
FROM and all subsequent JOINs, to be precise. They all generate a single namespace which SELECT uses. As far as I understand the grammar, FROM isn’t even a separate clause, but is itself a separator between a columnset and an expression of the form `t1 JOIN t2 ON cond12 JOIN t3 ON cond123 JOIN …`, where t<n> may be either a table name, or an arbitrarily nested subexpression of the same form.
[ Parent | on HN ]