sql-parser
pg-query-emscripten
| sql-parser | pg-query-emscripten | |
|---|---|---|
| 3 | 1 | |
| 423 | 73 | |
| 0.7% | - | |
| 9.2 | 0.0 | |
| 16 days ago | over 2 years ago | |
| PHP | C++ | |
| GNU General Public License v3.0 only | MIT License |
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.
sql-parser
-
Can SQL be used without an RDBMS?
You can tokenize the query using [sql-parser](https://github.com/phpmyadmin/sql-parser) and then write functions to load, filter, sort, and group data, if you really wanted to.
-
Row hyperlinks to foreign tables not showing
Hi! This is because ansi quotes are not yet supported: https://github.com/phpmyadmin/sql-parser/issues/284 What application does require ansi quotes?
-
Open Source SQL Parsers
SQL Parser in phpmyadmin is a validating SQL lexer and parser with a focus on MySQL dialect.
pg-query-emscripten
-
Open Source SQL Parsers
JS: psql-parser in Node and pg-query-emscripten in the browser
What are some alternatives?
ANTLR - ANTLR (ANother Tool for Language Recognition) is a powerful parser generator for reading, processing, executing, or translating structured text or binary files.
libpg_query - C library for accessing the PostgreSQL parser outside of the server environment
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
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_query - Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser
sqlparse - A non-validating SQL parser module for Python
pg_query_go - Go library to parse and normalize SQL queries using the PostgreSQL query parser