3 ms·
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..."?
by jessaustin 7y ago
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..."?
- nojvek 7y agoThere 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.
- mariushn 7y agoI started a discussion at https://www.postgresql.org/message-id/CAPUEYuYuJSRE_c_k%2BuBQReKUDZOMb3niiJ3mPuDP6AFdK_%2Bpiw%40mail.gmail.com https://www.postgresql.org/message-id/CAPUEYuYuJSRE_c_k%2BuB...