sql-format

Format your SQL statements using the sql-pretty-printer API.

Dependencies

This project uses the following modules:

• requests

Installation

To install, download the repository via:

git clone https://github.com/rrickgauer/sql-format.git

Usage

In the sql-format directory, use:

python sql-format.py

Example

sql-format will take the following SQL statement:

select Songs.id, Songs.title, Artists.name from Songs left join Artists on Songs.artist_id = Artists.id where Songs.id > 100 order by Songs.title desc limit 20;

and turns it into this:

SELECT Songs.id,
       Songs.title,
       Artists.name
FROM   Songs
       LEFT JOIN Artists
              ON Songs.artist_id = Artists.id
WHERE  Songs.id > 100
ORDER  BY Songs.title DESC
LIMIT  20;