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

• queryparser

  2 1,066 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

• sqlparse

  7 3,574 8.2 Python

  A non-validating SQL parser module for Python

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• rhizome

  8 814 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

• swifties

  5 11 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

• grammars-v4

  29 9,762 9.6 ANTLR

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

  

• langjam

  19 1,025 0.0
  

• go-mysql-server

  23 2,145 9.9 Go

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

  

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• vitess-sqlparser

  1 386 0.0 Go

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

  

• gosql

  2 667 0.0 Go

  An early PostgreSQL implementation in Go

• alasql

  4 6,884 9.1 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.

  

• sqlite-parser

  1 292 0.0 PLpgSQL

  Discontinued JavaScript implentation of SQLite 3 query parser

  

• JSqlParser

  4 4,938 9.2 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

  

• Presto

  14 15,582 9.9 Java

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

  

• zetasql

  15 2,127 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

• SaaSHub

  www.saashub.com sponsored

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

  

Suggest a related project