pganalyze/pg_query: Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser

This Ruby extension uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parsetree. In addition the extension allows you to normalize queries (replacing constant values with $n) and parse these normalized queries into a parsetree again. When you build this extension, it builds parts of the PostgreSQL server source (see libpg_query), and then statically links it into this extension. This may seem like a lot of complexity, but is the only reliable way of parsing all valid PostgreSQL queries. .