Skip to content

Sublime Text 2 command to format long SQL statement to a more readable form (also available via ST2 Package Control)

License

Notifications You must be signed in to change notification settings

dserodio/SublimeFormatSQL

 
 

Repository files navigation

Summary

FormatSQL formats long SQL statement to a more readable form by using python-sqlparse library.

How to Use

select sql and click menu Selection -> Format -> SQL

Configure key binding

add the following line to keymap settings

{ "keys": ["super+k", "super+s"], "command": "format_sql" },

Example

Original:

select a,b from foo join bar on val1 = val2 where id = 123 and cd = 99;

Formated:

SELECT a,
       b
FROM foo
JOIN bar ON val1 = val2
WHERE id = 123
    AND cd = 99;

License

python-sqlparse library and this code are both on 2-clauses BSD

About

Sublime Text 2 command to format long SQL statement to a more readable form (also available via ST2 Package Control)

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%