sqlparse is a non-validating SQL parser for Python. It provides support for parsing, splitting and formatting SQL statements.
The module is compatible with Python 3.5+ and released under the terms of the New BSD license.
Visit the project page at https://github.com/andialbrecht/sqlparse for further information about this project.
$ pip install sqlparse>>>importsqlparse>>># Split a string containing two SQL statements:>>>raw='select * from foo; select * from bar;'>>>statements=sqlparse.split(raw)
>>>statements
['select * from foo;', 'select * from bar;']
>>># Format the first statement and print it out:>>>first=statements[0]
>>>print(sqlparse.format(first, reindent=True, keyword_case='upper'))
SELECT*FROMfoo;
>>># Parsing a SQL statement:>>>parsed=sqlparse.parse('select * from foo')[0]
>>>parsed.tokens
[<DML'select'at0x7f22c5e15368>, <Whitespace' 'at0x7f22c5e153b0>, <Wildcard'*' … ]
>>>- Project page
- https://github.com/andialbrecht/sqlparse
- Bug tracker
- https://github.com/andialbrecht/sqlparse/issues
- Documentation
- https://sqlparse.readthedocs.io/
- Online Demo
- https://sqlformat.org/
sqlparse is licensed under the BSD license.
Parts of the code are based on pygments written by Georg Brandl and others. pygments-Homepage: http://pygments.org/