SQLFMT
SQLFMT - An uncompromising SQL query formatter.
SQLFMT is an uncompromising SQL query formatter, which provides one and only one way to format the SQL query. Our goal is to make code reviews faster by producing the smallest diffs possible. You will save time and mental energy on more important matters.
Please note this project is still in the planning stage and everything may be changed in the future.
How to install SQLFMT?
You can install SQLFMT from Python Package Index:
pip install sqlfmt
How to use SQLFMT?
Given a SQL file, you can simply use the following command to format it:
sqlfmt path/to/file.sql
You can install completion for a specfic shell:
sqlfmt --install-completion bash
You can also run the following command to find more other options:
sqlfmt --help
How does SQLFMT work?
It formats your SQL code in place.
For example, if you have a file containing the following SQL code:
SeLEct 1, blah as fOO from myTable
after running SQLFMT, the content of that file will become:
SELECT
1,
blah AS foo
FROM mytable