format-sql

Makes your SQL readable.

An example:

sql=""" SELECT country, product, SUM(profit) FROMsales left join x on x.id=sales.k GROUP BY country,product having f > 7 and fk=9 limit 5; """

Will result in:

sql=""" SELECT country, product, SUM(profit) FROM sales LEFT JOIN x ON x.id = sales.k GROUP BY country, product HAVING f > 7 AND fk = 9 LIMIT 5; """

Install format-sql via pip:

$ pip install format-sql

You can then just call format-sql with files and directories:

$ format-sql -h
usage: format-sql [-h] [--types TYPES] [-r] [--no-semicolon] [--version]
[--debug] [--dry-run]
paths [paths ...]
positional arguments:
paths
optional arguments:
-h, --help show this help message and exit
--types TYPES Only process these given file types.
-r, --recursive Process files found in subdirectories.
--no-semicolon Try to detect SQL queries with no trailing semicolon.
--version show program's version number and exit --debug Print available debug information. --dry-run Print the altered output and do not change the file.

For example:

$ format-sql my-file.py

Or recursively with directory:

$ format-sql -r my-directory/

You can try format-sql online: http://format-sql.de.