sqlalchemy-pretty-sql

Given a sqlalchemy query, display a well formatted and highlighted sql code.

Install and usage

pip install sqlalchemy-pretty-sql

And then just import the package in your notebook session

In[3]: import sqlalchemy_pretty_sql
In[4]: query

After sqlalchemy_pretty_sql is imported, its pretty_sql function is registered to display the sql of any sqlalchemy.orm.query.Query object.

See the example.

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

Source distribution for sqlalchemy-pretty-sql 0.4.0
File	Size	Uploaded
sqlalchemy-pretty-sql-0.4.0.tar.gz	2.4 kB	Jun 11, 2020	Details

Table of built distributions (wheels) for sqlalchemy-pretty-sql 0.4.0
File	Interpreter	ABI	Platform	Reset
sqlalchemy_pretty_sql-0.4.0-py2.py3-none-any.whl 3.4 kB Jun 11, 2020	Python 2, Python 3	none	any	Details

Total release size: 5.9 kB

Download URL	sqlalchemy-pretty-sql-0.4.0.tar.gz
Size	2.4 kB
Tags	Source
SHA-256 checksum How to use checksums	`89028233be44bb4efc1ff4fa4648c1e388e821c80a37ca8c653a413c751cbc4c`
BLAKE2b-256 checksum How to use checksums	`c3e23a15d7db83690eab20fb80465dccc6af3cebe1d00dafc7e8f9d390f54eb2`
Upload date	Jun 11, 2020
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.1.1 pkginfo/1.5.0.1 requests/2.20.0 setuptools/46.4.0 requests-toolbelt/0.9.1 tqdm/4.40.2 CPython/3.6.8`

Download URL	sqlalchemy_pretty_sql-0.4.0-py2.py3-none-any.whl
Size	3.4 kB
Tags	Python 2 Python 3
SHA-256 checksum How to use checksums	`750021ec0afe838a44983477be650c01e441f537ec3323cf2d573b53aa341954`
BLAKE2b-256 checksum How to use checksums	`85d7f68dc8af79a24b2cc581cc1cc35ba4fc8deca08363ef6f59a0aaf653d85a`
Upload date	Jun 11, 2020
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.1.1 pkginfo/1.5.0.1 requests/2.20.0 setuptools/46.4.0 requests-toolbelt/0.9.1 tqdm/4.40.2 CPython/3.6.8`