Open Source SQL Parsers

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

SurveyJS - 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.
surveyjs.io
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.
www.influxdata.com
featured
  1. tree-sitter-sql

    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

    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.

    SurveyJS logo
  3. DuckDB

    DuckDB is an analytical in-process SQL database management system

  4. prql

    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

    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

    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

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

  8. lezer-snowsql

  9. InfluxDB

    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.

    InfluxDB logo
  10. sqlschm

    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

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Cloud-Native Architectures: Building Resilient Systems

    2 projects | dev.to | 28 Apr 2025
  • Why You Shouldn’t Invest In Vector Databases?

    12 projects | dev.to | 24 Apr 2025
  • Reliably Replicating Data Between PostgreSQL and ClickHouse

    4 projects | news.ycombinator.com | 22 Feb 2025
  • RocksDB: Your Key-Value Store Powerhouse (and Why You Should Care)

    5 projects | dev.to | 16 Feb 2025
  • Outgrowing Postgres: Handling increased user concurrency

    13 projects | dev.to | 3 Feb 2025

Did you know that JavaScript is
the 3rd most popular programming language
based on number of references?