Parsing SQL

1. zetasql

   1 21 2,386 0.0 C++

   ZetaSQL - Analyzer Framework for SQL

   

   If you don't want to do it yourself, there's this:

   https://github.com/google/zetasql

   Parsing is huge but it's amazing how small a part of the job it is. This library isn't even the half of it.

2. InfluxDB

   influxdata.com featured

   InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

   

3. sql-parse

   2 1 19 7.1 Rust

   Sql parser for rust

   

   Parsing SQL can solve many problems, but before writing/choosing a parser you need to know what your goal is. For example, at work we wanted to have statically-typed SQL statements in Python/mypy to statically identify syntax errors, misspelled column names and bad type mixes. We came up with a home-grown SQL parser [1] and type checker [2] in Rust and a mypy plugin [3]. If someone knows of other solutions for obtaining SQL/mypy integration I'd love to know about it, since parsing SQL is not exactly supposed to be our field of work.

   [1] https://github.com/antialize/sql-parse/blob/7869595aa92aed0b...

4. sql-type

   3 1 0 6.9 Rust

   

5. py-mysql-type-plugin

   4 2 0 5.4 Python

   Mypy plugin to type sql

   

6. go-mysql-server

   5 23 2,414 9.8 Go

   A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.

   

7. hasql-th

   6 4 112 5.6 Haskell

   Template Haskell utilities for Hasql

   

   unexpected '&'

   https://github.com/nikita-volkov/hasql-th#error-example-1

8. js-miniquery

   7 1 1 3.9 JavaScript

   SQL Where like filter expression for sequelize

   

9. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

Suggest a related project