Helper to beautify SQL statements. Works as file or pipe.

sqlpp.rb

#!/usr/bin/env ruby
require 'open3'

# # Dependencies
# `sqlformat` and `pygmentize` are Python programs :/
# make sure it's installed and available in your path.
# ```
# $ pip install --upgrade sqlparse
# $ pip install --upgrade pygment
# $ export PATH=$PATH:~/Library/Python/3.5/bin

sql = ARGF.read.strip
cmd = 'sqlformat -k upper -i lower --reindent_aligned -' + ($stdout.isatty ? '| pygmentize -g -l sql' : '')
out, _status = Open3.capture2(cmd, stdin_data: sql)
puts out

Would be great if someone could convert this to a pure Python script...

ln -s sqlpp.rb /usr/local/bin/sqlpp
chmod +x sqlpp.rb

sqlpp something.sql
pbpaste | sqlpp
pbpaste | sqlpp | pbcopy  # paste in your IDE.

Is this what you are looking for?

# prettySQL.py
#!/usr/bin/env python
import sys
import sqlparse
from pygments import highlight
from pygments.lexers import get_lexer_by_name
from pygments.formatters import TerminalTrueColorFormatter

def prettyPrint(file_name):
    raw_sql = open(file_name, 'r')
    lexer = get_lexer_by_name('sql', stripall=True)
    formatter = TerminalTrueColorFormatter()
    formatted_sql = sqlparse.format(raw_sql, encoding=None, keyword_case='upper', identifier_case='lower', reindent=True)

    return highlight(formatted_sql, lexer, formatter)

if __name__ == '__main__':
    print(prettyPrint(sys.argv[-1]))

-- test.sql
SELECT * FROM foos WHERE foo.blah > 0;

 » ./prettySQL.py test.sql
SELECT *
FROM foos
WHERE foo.blah > 0;