Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser

02-Apr-2020 459
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 ?) 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 is slightly crazy, but is the only reliable way of parsing all valid PostgreSQL queries.You can find further examples and a longer rationale here: https://pganalyze.com/blog/parse-postgresql-queries-in-ruby.html.
Use coupon code:

RUBYONRAILS

to get 30% discount on our bundle!
Prepare for your next tech interview with our comprehensive collection of programming interview guides. Covering JavaScript, Ruby on Rails, React, and Python, these highly-rated books offer thousands of essential questions and answers to boost your interview success. Buy our 'Ultimate Job Interview Preparation eBook Bundle' featuring 2200+ questions across multiple languages. Ultimate Job Interview Preparation eBook Bundle