Simple VimL-Python script that uses sqlformat.org to format the selected string

sqlformat.vim

" format SQL using sqlformat.org
function! SQLFormat() " {{{
'<,'>python << EOF
import vim
import urllib2, urllib, json
sql = ' '.join(vim.current.range)
params = {'sql': sql,
          'n_indents': 4,
          'keyword_case': 'upper',
          'reindent': 1}
response = urllib2.urlopen('http://sqlformat.org/api/v1/format',
                           data=urllib.urlencode(params))
data = json.loads(response.read())
lines = str.splitlines(str(data['result']))
vim.current.range.append([line for line in lines if line != ''])
vim.command('\'<,\'>d')
EOF
endfunction " }}}