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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: parser that could handle "FROM... SELECT..." as well as"SELECT... FROM..."
Дата
Msg-id CAFj8pRCsrM=2=Tz0=PGHntcWFSNV4ig4kxdY4sSRQ0M0t1QVhw@mail.gmail.com
обсуждение исходный текст
Ответ на parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..."  (Marius Andreiana <marius.andreiana@gmail.com>)
Ответы Re: parser that could handle "FROM... SELECT..." as well as"SELECT... FROM..."
Re: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..."
Список pgsql-sql
Дерево обсуждения
Hi

út 8. 10. 2019 v 8:12 odesílatel Marius Andreiana <marius.andreiana@gmail.com> napsal:
Hello Postgres folks,

After reading
I'd also like to write "FROM... SELECT..." instead of "SELECT... FROM...".

This article is little bit strange, it mix syntax and execution together 

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

PostgreSQL supports ANSI/SQL.  ANSI/SQL doesn't allow use clauses in any order.

Personally I don't see any benefit of proposed feature - It breaks portability of SQL queries (that is not high today).

Regards

Pavel


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

В списке pgsql-sql по дате отправления:

Предыдущее
От: Marius Andreiana
Дата:
Сообщение: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..."
Следующее
От: Marius Andreiana
Дата:
Сообщение: Re: parser that could handle "FROM... SELECT..." as well as"SELECT... FROM..."