pglast
JSqlParser
| pglast | JSqlParser | |
|---|---|---|
| 2 | 4 | |
| 337 | 4,965 | |
| - | 1.0% | |
| 8.9 | 9.4 | |
| 23 days ago | 7 days ago | |
| Python | Java | |
| - | 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.
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
JSqlParser
-
Semantic Diff for SQL
I wonder if this is a topical thread to check if anyone is aware of a Java based solution to parse a CREATE VIEW statement to get a mapping between the view columns and the corresponding source table columns. I checked out jsqlparser[0] and it does produce an AST which can be parsed using the visitor-pattern[1] but was wondering if there is a more "out-of-the-box" solution. Due to various reasons, querying the database information schema is not an option I can pursue.
[0]: https://github.com/JSQLParser/JSqlParser
[1]: https://en.wikipedia.org/wiki/Visitor_pattern
-
Open Source SQL Parsers
JSQLParser can parse multiple SQL dialects like MySQL, Postgres and Oracle. The grammar can be modified to support other SQL dialects.
- Let's write a compiler, part 5: A code generator
-
Racket v8.0
Interesting coincidence - I'm working on a parser that parses the AST produced by JSqlParser[0] for a create view statement to generate mapping between the columns of a view and the columns of its underlying table. It is an interesting example of having to use the visitor pattern[1].
[0]: https://github.com/JSQLParser/JSqlParser
What are some alternatives?
libpg_query - C library for accessing the PostgreSQL parser outside of the server environment
Apache Calcite - Apache Calcite
sql-parser - A validating SQL lexer and parser with a focus on MySQL dialect.
sqlglot - Python SQL Parser and Transpiler
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 - 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
Presto - The official home of the Presto distributed SQL query engine for big data
queryparser - Parsing and analysis of Vertica, Hive, and Presto SQL.