Awesome GitHub RepositoriesSQL Parsers

sqlglot is a SQL parser and transpiler that represents queries as abstract syntax trees to enable structural analysis, modification, and semantic transformation. It functions as a dialect translator and query optimizer, converting SQL code between different database engines and simplifying syntax trees through rule-based normalization. The project provides a framework for defining custom SQL dialects by overriding tokenizers, parsers, and generators. It includes a lineage analyzer to track data flow from source tables through complex queries to identify the origin of specific columns. Additi

jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time validation of SQL syntax and data types. Its core identity is built around a fluent DSL that mirrors SQL structure, a code generator that maps tables, views, and routines to Java objects, and a multi-dialect engine that translates the same DSL into vendor-specific SQL for over 30 databases. The project also includes a SQL parser and transformer for refactoring or dialect conversion, reactive stream integration for non-blocking query execution, and a JDBC proxy diagnostics tool f

JSqlParser 是一个 Java SQL 查询解析库，将原始 SQL 字符串转换为强类型 Java 对象的结构化层级。它通过将数据库查询表示为对象树，提供了程序化分析和操作数据库查询的方法。 该库支持解析现有 SQL 文本以及通过流畅 API 程序化生成新语句。它包括转换查询树并将结构化对象模型序列化回格式化 SQL 文本的机制。 其他功能包括数据库模式分析（例如提取表名以映射数据依赖关系）和 SQL 语法验证。该解析器可配置以处理不同的语法方言，并包括容错恢复功能，以便在遇到无效标记后继续处理脚本。

sqlparse 是一个用于 SQL 语句程序化分析和操作的 Python 库。它提供了一个非验证解析器，将 SQL 文本分解为标记，并提供了一个将包含多个查询的字符串划分为单个语句的实用程序。 该项目包括一个代码格式化程序，使用一致的缩进和关键字大小写来重组 SQL 语句。它还提供了通过版本控制钩子自动化此格式化和 Linting 过程的机制，以保持代码一致性。

Let's make a SQL parser so we can provide a familiar interface to non-sql datastores!