pgsql-parser
pg-proto-parser
pgsql-parser | pg-proto-parser | |
---|---|---|
2 | 1 | |
120 | 7 | |
0.8% | - | |
8.8 | 9.3 | |
1 day ago | about 1 month ago | |
PLpgSQL | TypeScript | |
MIT License | Apache License 2.0 |
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.
pgsql-parser
-
From Postgres Proto to TypeScript – new transpiler for tooling
pgsql-parser: https://github.com/launchql/pgsql-parser
Additionally, we now have new utilities generated by the proto parser, make sure to checkout the @pgsql/utils! That has some cool features in it:
@pgsql/enums: https://github.com/launchql/pgsql-parser/tree/main/packages/...
-
Open Source SQL Parsers
JS: psql-parser in Node and pg-query-emscripten in the browser
pg-proto-parser
-
From Postgres Proto to TypeScript – new transpiler for tooling
My journey to upgrade pgsql-parser to TypeScript led to an exciting discovery in the pganalyze/libpg_query repository: protobuf files defining PostgreSQL's AST. This discovery inspired me to create a proto-to-TypeScript transpiler, streamlining the process of typing the pgsql-parser and unlocking other cool new features :)
The transpiler not only allowed me to add typing for pgsql-parser but also spawned a suite of TypeScript utilities that are invaluable for PostgreSQL development.
Explore the tools:
pg-proto-parser: https://github.com/launchql/pg-proto-parser
What are some alternatives?
zetasql - ZetaSQL - Analyzer Framework for SQL
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
Apache Calcite - Apache Calcite
parser - A MySQL Compatible SQL Parser
pg_query_go - Go library to parse and normalize SQL queries using the PostgreSQL query parser
pg_parse - PostgreSQL parser for Rust that uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parse tree.
sql-parser - A validating SQL lexer and parser with a focus on MySQL dialect.
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