parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..."

From: Marius Andreiana <marius(dot)andreiana(at)gmail(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..."
Date: 2019-10-08 06:12:15
Message-ID: CAPUEYuYuJSRE_c_k+uBQReKUDZOMb3niiJ3mPuDP6AFdK_+piw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello Postgres folks,

After reading
https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/
and the discussions at https://news.ycombinator.com/item?id=21150606
I'd also like to write "FROM... SELECT..." instead of "SELECT... FROM...".

Postgres doesn't support this though. Would it be possible to please add
parsing support for this syntax as well?

Somebody mentioned:
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.

Thanks!
Marius

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2019-10-08 06:32:01 Re: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..."
Previous Message Pepe TD Vo 2019-10-04 15:53:32 Re: Automatically updating a new information column in PostgreSQL