question on parsing postgres sql queries

From: Jerome Wagner <jerome(dot)wagner(at)m4x(dot)org>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: question on parsing postgres sql queries
Date: 2016-07-26 09:20:35
Message-ID: CA+=V_fMOf58U3ZBJqhrdrsW1rs3OAHPpOhKc5yR9PHUWyLUW-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

Hello,

I am doing some research on postgres sql query parsing.

I have found the https://github.com/lfittl/libpg_query project which
manages to re-use the native postgres server parser. For using this, you
need to accept an external dependency on a lib compiled out of the postgres
source.

I was wondering what people think of the conformance with regards to the
real parser of the documentations on
- https://www.postgresql.org/docs/current/static/sql-select.html
- https://www.postgresql.org/docs/current/static/sql-copy.html
... and more generally sgmls in
https://github.com/postgres/postgres/tree/master/doc/src/sgml/ref

Would it make sense to use these sgml synopsis as some kind of source of
truth, parse them, and automatically generate a parser for a specifc
language ?

This could enable the creation of parsers for different languages using
parser generators based on the synopsis.

I feel like the conformance level of the documentation is high and that the
sgml synopis seem to be nearly programmatically sufficient to create
parsers.

what do you think ?

Could the parser commiters share some lights on how the documentation
process interacts with the parser commits ?

Thanks,
Jerome

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Kevin Grittner 2016-07-27 21:36:13 Re: question on parsing postgres sql queries
Previous Message Michael Paquier 2016-07-21 23:35:32 Re: pg_rewind confusion

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2016-07-26 09:21:19 Re: [GENERAL] RE: [GENERAL] Re: [GENERAL] A simple extension immitating pg_notify‏
Previous Message Michael Paquier 2016-07-26 09:08:56 Re: pg_dumping extensions having sequences with 9.6beta3