sqlglot

SQL parser and transpiler

A comprehensive Python library for parsing and transpiling various SQL dialects to ensure compatibility and correctness.

Python SQL Parser and Transpiler

GitHub

7k stars
42 watching
730 forks
Language: Python
last commit: 2 months ago
Linked from 1 awesome list

bigqueryclickhousedatabricksduckdbhivemysqloptimizerparserpostgresprestopythonredshiftsnowflakesparksqlsqlitesqlparsertranspilertrinotsql

Backlinks from these awesome lists:

Related projects:

Repository Description Stars
sqlfluff/sqlfluff A tool that analyzes and formats SQL code to improve readability and quality. 8,349
andialbrecht/sqlparse A Python module for parsing and formatting SQL statements. 3,778
defog-ai/sqlcoder An AI model that converts natural language questions to SQL queries 3,445
sql-formatter-org/sql-formatter A JavaScript library that formats and pretty-prints SQL queries in various dialects. 2,402
xo/xo A tool that generates idiomatic Go code for SQL databases based on their schema or custom queries. 3,748
encode/databases An asynchronous Python library providing support for querying multiple databases using SQLAlchemy core expressions. 3,853
sqlc-dev/sqlc Generates type-safe code from SQL queries 13,704
sqlalchemy/sqlalchemy A powerful library providing an object-relational mapping system to interact with databases in a Pythonic way. 9,807
duckdb/duckdb A high-performance analytical database system with support for complex queries and extensions to standard SQL. 25,034
sqlmapproject/sqlmap A tool designed to detect and exploit SQL injection flaws in databases, allowing penetration testing and takeover 32,841
launchbadge/sqlx A high-level, async Rust library for interacting with relational databases. 13,661
r0oth3x49/ghauri Automates detection and exploitation of SQL injection security flaws using a cross-platform tool. 3,208
google/zetasql A framework for analyzing and understanding SQL queries, providing a common language and behavior across different query engines. 2,337
sqlchat/sqlchat A chat-based interface for interacting with various databases using natural language queries. 4,712
python-gino/gino An asynchronous Python ORM built on top of SQLAlchemy core 2,686