pg_parse
PostgreSQL parser for Rust that uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parse tree. (by paupino)
pg_query_go
Go library to parse and normalize SQL queries using the PostgreSQL query parser (by pganalyze)
Our great sponsors
| pg_parse | pg_query_go | |
|---|---|---|
| 1 | 3 | |
| 67 | 604 | |
| - | 3.5% | |
| 3.9 | 6.2 | |
| 3 months ago | about 2 months ago | |
| Rust | C | |
| MIT License | BSD 3-clause "New" or "Revised" 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.
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_parse
Posts with mentions or reviews of pg_parse.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-10-08.
-
Open Source SQL Parsers
Rust: pg_query.rs
pg_query_go
Posts with mentions or reviews of pg_query_go.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-08-25.
-
How we explored the best practices of GoReleaser X CGO
When implementing SQL Review for PostgreSQL, we introduced pg_query_go as the PostgreSQL parser. The pg_query_go uses the native PostgreSQL parser via C bind, which naturally requires CGO support.
-
sqlc: Generating go code from sql statements
If you are using Postgres then you are lucky! sqlc uses the official postgres parser (https://github.com/pganalyze/pg_query_go) and while I have never tried it, I guess it works really well.
-
Open Source SQL Parsers
Golang: pg_query_go
What are some alternatives?
When comparing pg_parse and pg_query_go you can also consider the following projects:
libpg_query - C library for accessing the PostgreSQL parser outside of the server environment
pg_query - Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query 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
zetasql - ZetaSQL - Analyzer Framework for SQL
ANTLR - ANTLR (ANother Tool for Language Recognition) is a powerful parser generator for reading, processing, executing, or translating structured text or binary files.
Apache Hive - Apache Hive
pg-query-emscripten - Emscripten Port of pg_query to easily play with it in the browser
parser - A MySQL Compatible SQL Parser