Hacker News new | ask | show | jobs
by lmwnshn 1526 days ago
On the other hand, you're probably writing your SQL parser to parse SQL queries that are being fed into some DBMS. I found pg_query's argument convincing: "Our conclusion: The only way to correctly parse all valid SQL queries that PostgreSQL understands, now and in the future, is to use PostgreSQL itself." [0]

[0] https://pganalyze.com/blog/parse-postgresql-queries-in-ruby