Open Source SQL Parsers

1. tree-sitter-sql

   1 6 185 8.3 JavaScript

   SQL grammar for tree-sitter

   

   I'm using a tree-sitter grammar^1, which category the OP doesn't mention, to index database object references in data access code and process schema migrations^2. The idea is early detection of potentially-dangerous database changes that modify or drop tables/views still used elsewhere, across the entire organization's code. It's already saved my bacon a few times.

   ^1 specifically https://github.com/DerekStride/tree-sitter-sql , but there are a few others around too

2. SurveyJS

   surveyjs.io featured

   JavaScript Form Builder with No-Code UI & Built-In JSON Schema Editor. Add the SurveyJS white-label form builder to your JavaScript app (React/Angular/Vue3). Build complex JSON forms without coding. Fully customizable, works with any backend, perfect for data-heavy apps. Learn more.

   

3. DuckDB

   2 69 29,168 10.0 C++

   DuckDB is an analytical in-process SQL database management system

   

4. prql

   3 129 10,289 9.6 Rust

   PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement

   

   Then limit

   The order of operations are out of whack and makes pipeline ing a little hard.

   I found this to be closer to LINQ way

   https://github.com/prql/prql

   I hope in near future databases will come with better query languages...

5. hasql-th

   4 4 112 5.6 Haskell

   Template Haskell utilities for Hasql

   

   There is also a Haskell port of the original PostgreSQL parser, implemented using megaparsec, which makes it highly flexible and hackable: https://github.com/nikita-volkov/hasql-th#implementation

6. grammars-v4

   5 35 10,598 9.2 ANTLR

   Grammars written for ANTLR v4; expectation that the grammars are free of actions.

   

   I believe antlr has grammars for other sql syntaxes (sqlite, tsql, etc): https://github.com/antlr/grammars-v4/tree/master/sql

7. tree-sitter-sql

   6 4 114 1.9 JavaScript

   SQL syntax highlighting for tree-sitter (by m-novikov)

   

8. lezer-snowsql

   7 1 22 0.0 JavaScript

   

9. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

10. sqlschm

    8 2 5 2.4 Python

    A SQLite Schema Parser

    

    SQL is a mess. It is difficult to find a parser that fulfills your needs.

    A month ago, I needed a parser to parse SQLite schemas. SQLite has some edge case and I needed a lossless parsing to detect these edge cases.

    I finally wrote my own parser [1] to fullfill my needs and to have some fun. This is for a POC project.

    [1] https://github.com/coast-team/sqlschm

Suggest a related project