Folders and files

Name		Name	Last commit message	Last commit date
Latest commit History 1,324 Commits
.github		.github
docs		docs
examples		examples
sqlparse		sqlparse
tests		tests
.flake8		.flake8
.gitignore		.gitignore
.readthedocs.yaml		.readthedocs.yaml
AUTHORS		AUTHORS
CHANGELOG		CHANGELOG
CONTRIBUTING.md		CONTRIBUTING.md
LICENSE		LICENSE
Makefile		Makefile
README.rst		README.rst
SECURITY.md		SECURITY.md
TODO		TODO
pixi.lock		pixi.lock
pyproject.toml		pyproject.toml

Repository files navigation

python-sqlparse - Parse SQL statements

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.8+ and released under the terms of theNew BSD license.

Visit the project page athttps://github.com/andialbrecht/sqlparse forfurther information about this project.

Quick Start

$ 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'*' … ]>>>