andialbrecht/sqlparse
Sqlparse
sqlparse is a Python library for the programmatic analysis and manipulation of SQL statements. It provides a non-validating parser that breaks down SQL text into tokens and a utility to divide strings containing multiple queries into individual statements.
The project includes a code formatter that reorganizes SQL statements using consistent indentation and keyword casing. It also provides mechanisms for automating this formatting and linting process through version control hooks to maintain code consistency.
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.
