Let's write a compiler, part 5: A code generator

1. queryparser

   1 2 1,078 0.0 Haskell

   Parsing and analysis of Vertica, Hive, and Presto SQL.

   

   3. Would you use a different language/library then I picked?

   Thanks :)

   [1] https://github.com/uber/queryparser

2. 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.

   

3. sqlparse

   2 7 3,834 7.6 Python

   A non-validating SQL parser module for Python

   

4. rhizome

   3 8 817 1.8 Ruby

   A JIT for Ruby, implemented in pure Ruby

   

   Lots of compiler tutorials are like this - there's very little out there to explain how compilers really work.

   This is my effort - trying to show genuine data structures and processes.

   https://github.com/chrisseaton/rhizome

5. swifties

   4 5 12 0.0 Swift

   a custom language construction kit

   

   Depends on the complexity of your queries, but if you have a narrow subset that you're interested in, implementing a recursive descent parser for just those parts of the syntax that fits your problem like a glove could be a better solution.

   https://github.com/codr7/swifties

6. grammars-v4

   5 35 10,470 9.4 ANTLR

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

   

7. langjam

   6 19 1,016 0.0

   

8. go-mysql-server

   7 23 2,404 9.8 Go

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

   

9. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

10. vitess-sqlparser

    8 1 460 0.0 Go

    simply SQL Parser for Go ( powered by vitess and TiDB )

    

11. gosql

    9 3 715 0.0 Go

    An early PostgreSQL implementation in Go

    

12. alasql

    10 5 7,107 9.0 JavaScript

    AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

    

13. sqlite-parser

    11 1 292 0.0 PLpgSQL

    Discontinued JavaScript implentation of SQLite 3 query parser

    

14. JSqlParser

    12 4 5,609 9.4 Java

    JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

    

15. Presto

    13 15 16,272 9.9 Java

    The official home of the Presto distributed SQL query engine for big data

    

16. zetasql

    14 21 2,376 0.0 C++

    ZetaSQL - Analyzer Framework for SQL

    

    ZetaSQL[1] seems like it could be a fit for your use case. I've worked with Apache Calcite in the past and found it to be very complex to work with. I found ZetaSQL to be a little easier to use.

    [1] https://github.com/google/zetasql

17. SaaSHub

    www.saashub.com featured

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    

Suggest a related project