pg_query_go
Go library to parse and normalize SQL queries using the PostgreSQL query parser (by pganalyze)
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 | pg_parse | |
|---|---|---|
| 3 | 1 | |
| 607 | 67 | |
| 2.0% | - | |
| 5.8 | 3.9 | |
| 6 days ago | 3 months ago | |
| C | Rust | |
| 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.
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_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
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
What are some alternatives?
When comparing pg_query_go and pg_parse you can also consider the following projects:
pg_query - Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser
libpg_query - C library for accessing the PostgreSQL parser outside of the server environment
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
ANTLR - ANTLR (ANother Tool for Language Recognition) is a powerful parser generator for reading, processing, executing, or translating structured text or binary files.
zetasql - ZetaSQL - Analyzer Framework for SQL
pg-query-emscripten - Emscripten Port of pg_query to easily play with it in the browser
Apache Hive - Apache Hive
parser - A MySQL Compatible SQL Parser