Python SQL Parser and Transpiler
You should try it out and see. Here are the test cases
I can even parse and optimizer TPC-H https://github.com/tobymao/sqlglot/blob/main/tests/fixtures/....
SQLGlot's parser handles a superset of SQL, so it's much more flexible than any one engine.
Learn any GitHub repo in 59 seconds. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev.
DuckDB is an in-process SQL OLAP Database Management System
ZetaSQL - Analyzer Framework for SQL
How to manipulate SQL string programmatically?
2 projects | /r/dataengineering | 28 Apr 2023
SQL server to postgreSQL migration
2 projects | /r/dotnet | 23 Feb 2023
DuckDB – in-process SQL OLAP database management system
4 projects | news.ycombinator.com | 10 Feb 2023
MySQL-mimic - Python implementation of the MySQL server wire protocol.
4 projects | /r/Python | 31 Oct 2022
"Query Oracle + Sql"
2 projects | /r/dataengineering | 17 Oct 2022