sql-parser
pglast
sql-parser | pglast | |
---|---|---|
3 | 2 | |
423 | 337 | |
0.7% | - | |
9.2 | 8.9 | |
13 days ago | 22 days ago | |
PHP | Python | |
GNU General Public License v3.0 only | - |
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.
pglast
-
Show HN: Postgres Language Server
Can't you just give some love to the issue https://github.com/pganalyze/libpg_query/issues/44 instead ? As I said before this would be very helpful for the community because there are a lot of libraries that use libpg_query and cannot be used on windows (f.e see https://github.com/lelit/pglast/issues/7).
It seems that the only problem for fixing the problem is:
> Thanks for the offer, but the problem is our team being time limited / having an engineer with a Windows machine ready to take this on, not that we wouldn't want to pay someone to work on it :)
(https://github.com/pganalyze/libpg_query/issues/44#issuecomm...)
Hosting the LSP elsewhere is really needed since if people wanted to go that way they could use Remote ssh (https://code.visualstudio.com/docs/remote/ssh) to host the whole dev environment on linux and connect to it.
Thank you
-
Open Source SQL Parsers
Python: pglast
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!
Apache Calcite - Apache Calcite
pg_query - Ruby extension to parse, deparse and normalize SQL queries using the PostgreSQL query parser
pg_query_go - Go library to parse and normalize SQL queries using the PostgreSQL query parser
sqlparse - A non-validating SQL parser module for Python
JSqlParser - JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
zetasql - ZetaSQL - Analyzer Framework for SQL
queryparser - Parsing and analysis of Vertica, Hive, and Presto SQL.