News for hackers. Stuff that matters.
Re:SQL queries don't start with SELECT by jessaustin on Thursday October 03, 2019 @07:13PM (#21153259)
Would there be any conceptual barrier to a particular DB engine getting an updated parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..."?
Re:SQL queries don't start with SELECT by nojvek on Thursday October 03, 2019 @08:56PM (#21153893)
There shouldn’t be. Engines don’t run sql directly. They make an AST, make an intermediate representation of instructions and then execute.

So if it results in same AST, the parser should be flexible. Someone should make PRs for mysql, slqlite and Postgres.

If those three have it, other engines will catch up real fast.

Re:SQL queries don't start with SELECT by mariushn on Tuesday October 08, 2019 @03:14AM (#21189575)