sqlparse

sqlparse is a non-validating SQL parser module. It provides support for parsing, splitting and formatting SQL statements.

Visit the project page for additional information and documentation.

Example Usage

Splitting SQL statements:

>>> import sqlparse
>>> sqlparse.split('select * from foo; select * from bar;')
[u'select * from foo; ', u'select * from bar;']

Formatting statements:

>>> sql = 'select * from foo where id in (select id from bar);'
>>> print sqlparse.format(sql, reindent=True, keyword_case='upper')
SELECT *
FROM foo
WHERE id IN
  (SELECT id
   FROM bar);

Parsing:

>>> sql = 'select * from someschema.mytable where id = 1'
>>> res = sqlparse.parse(sql)
>>> res
(<Statement 'select...' at 0x9ad08ec>,)
>>> stmt = res[0]
>>> str(stmt)  # converting it back to unicode
'select * from someschema.mytable where id = 1'
>>> # This is how the internal representation looks like:
>>> stmt.tokens
(<DML 'select' at 0x9b63c34>,
 <Whitespace ' ' at 0x9b63e8c>,
 <Operator '*' at 0x9b63e64>,
 <Whitespace ' ' at 0x9b63c5c>,
 <Keyword 'from' at 0x9b63c84>,
 <Whitespace ' ' at 0x9b63cd4>,
 <Identifier 'somes...' at 0x9b5c62c>,
 <Whitespace ' ' at 0x9b63f04>,
 <Where 'where ...' at 0x9b5caac>)

Release files for sqlparse 0.3.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqlparse 0.3.0
File	Size	Uploaded
sqlparse-0.3.0.tar.gz	64.1 kB	Mar 11, 2019	Details

Built distribution (wheel)

Table of built distributions (wheels) for sqlparse 0.3.0
File	Interpreter	ABI	Platform	Reset
sqlparse-0.3.0-py2.py3-none-any.whl 39.7 kB Mar 11, 2019	Python 2, Python 3	none	any	Details

Total release size: 103.7 kB

Release files / sqlparse-0.3.0.tar.gz

Download URL	sqlparse-0.3.0.tar.gz
Size	64.1 kB
Tags	Source
SHA-256 checksum How to use checksums	`7c3dca29c022744e95b547e867cee89f4fce4373f3549ccd8797d8eb52cdb873`
BLAKE2b-256 checksum How to use checksums	`63c8229dfd2d18663b375975d953e2bdc06d0eed714f93dcb7732f39e349c438`
Upload date	Mar 11, 2019
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.7.2`

Release files / sqlparse-0.3.0-py2.py3-none-any.whl

Download URL	sqlparse-0.3.0-py2.py3-none-any.whl
Size	39.7 kB
Tags	Python 2 Python 3
SHA-256 checksum How to use checksums	`40afe6b8d4b1117e7dff5504d7a8ce07d9a1b15aeeade8a2d10f130a834f8177`
BLAKE2b-256 checksum How to use checksums	`ef53900f7d2a54557c6a37886585a91336520e5539e3ae2423ff1102daf4f3a7`
Upload date	Mar 11, 2019
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.7.2`