SQLAI.ai

SQL formatter settings

Set custom SQL formatting rules.

Example SQL query

            
              
            
            select supplier_name,city from
(select * from suppliers join addresses on suppliers.address_id=addresses.id)
as suppliers
where supplier_id>500
order by supplier_name asc,city desc;

SQL formatting rules are applied when clicking the formatter button above the generation, i.e. icon.

Tab width

Use tabs

Uses TAB characters for indentation.

Keyword case

Converts reserved keywords to upper- or lowercase.

Data type case

Converts data types to upper- or lowercase.

Function case

Converts function names to upper- or lowercase.

Identifier case

Converts identifiers to upper- or lowercase. Only unquoted identifiers are converted (experimental).

Indentation style

Defines overall indentation style (deprecated).

AND/OR newlines

Newline before or after boolean operator (AND, OR, XOR).

Expression width

Determines maximum length of parenthesized expressions.

Lines between queries

Decides how many empty lines to leave between SQL statements.

Dense operators

Decides whitespace around operators.

Semicolon on separate line

Whether to place query separator (;) on a separate line.