pg_query VS pgsql-parser

Compare pg_query vs pgsql-parser and see what are their differences.

pg_query

Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser (by pganalyze)

pgsql-parser

PostgreSQL Query Parser for Node.js (by launchql)
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
pg_query pgsql-parser
1 2
760 121
2.1% 2.5%
5.6 8.8
4 days ago 18 days ago
C PLpgSQL
BSD 3-clause "New" or "Revised" License MIT License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

pg_query

Posts with mentions or reviews of pg_query. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-10-08.

pgsql-parser

Posts with mentions or reviews of pgsql-parser. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-03-31.

What are some alternatives?

When comparing pg_query and pgsql-parser you can also consider the following projects:

mo-sql-parsing - Let's make a SQL parser so we can provide a familiar interface to non-sql datastores!

zetasql - ZetaSQL - Analyzer Framework for SQL

pg_query_go - Go library to parse and normalize SQL queries using the PostgreSQL query parser

libpg_query - C library for accessing the PostgreSQL parser outside of the server environment

Apache Calcite - Apache Calcite

parser - A MySQL Compatible SQL Parser

pglast - PostgreSQL Languages AST and statements prettifier: master branch covers PG10, v2 branch covers PG12, v3 covers PG13, v4 covers PG14, v5 covers PG15, v6 covers PG16

pg_parse - PostgreSQL parser for Rust that uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parse tree.