Plurrrr

Tue 03 Jan 2023

Writing a Python SQL engine from scratch

When I first started writing SQLGlot in early 2021, my goal was just to translate SQL queries from SparkSQL to Presto and vice versa. However, over the last year and a half, I've ended up with a full-fledged SQL engine. SQLGlot can now parse and transpile between 18 SQL dialects and can execute all 24 TPC-H SQL queries. The parser and engine are all written from scratch using Python.

Source: Writing a Python SQL engine from scratch, an article by Toby Mao.