andialbrecht/sqlparse
Sqlparse
sqlparse 是一个用于 SQL 语句程序化分析和操作的 Python 库。它提供了一个非验证解析器，将 SQL 文本分解为标记，并提供了一个将包含多个查询的字符串划分为单个语句的实用程序。
该项目包括一个代码格式化程序，使用一致的缩进和关键字大小写来重组 SQL 语句。它还提供了通过版本控制钩子自动化此格式化和 Linting 过程的机制，以保持代码一致性。
Features
- SQL Parsers - Provides a non-validating Python library for breaking down SQL statements into tokens for analysis.
- SQL Formatting - Offers utilities for pretty-printing and beautifying SQL code via consistent indentation and casing.
- SQL Formatters - Reorganizes SQL statements with consistent indentation and keyword casing to improve readability.
- Script Splitting - Divides large strings of multiple SQL commands into individual statements for sequential execution.
- SQL Statement Parsing - Identifies and groups SQL statements based on delimiters to split complex scripts into individual queries.
- String Splitting - Dividing strings containing multiple SQL queries into separate statements while respecting nested parentheses and quotes.
- SQL Analysis and Linting - Integrates formatting into commit hooks to ensure SQL code consistency through automated linting.
- Formatting Automations - Provides integration for automatically cleaning and formatting SQL files via version control hooks.
- Indentation Depth Tracking - Tracks nesting depth of SQL clauses to apply consistent leading whitespace and alignment.
- Keyword Normalizations - Implements mapping of SQL keywords to a consistent casing format via a predefined dictionary.
- Regular Expression-Based Parsing - Uses compiled regular expression patterns to categorize SQL keywords and operators during lexing.
- String Tokenization - Provides a mechanism to break SQL strings into discrete tokens based on patterns for further analysis.
- Token Grouping - Clusters tokens into nested groups to create a hierarchical representation of SQL queries.
- SQL Parsers - Non-validating SQL parser for Python.
- Text Processing - Provides a non-validating parser for SQL statements.
