Keyword Case

• Options: UPPER, Lower, Title
• Default: UPPER
• Example:
  • UPPER: SELECT * FROM users WHERE active = 1
  • Lower: select * from users where active = 1
  • Title: Select * From Users Where Active = 1

Spaces Per Indent

• Default: 4 spaces
• Description: Number of spaces for each indentation level
• Range: Any positive integer

Initial Indent Level

• Default: 0
• Description: Starting indentation level for formatted SQL
• Use Case: Set starting indentation when embedding SQL in other code

Comma Positioning (Columns & IN Lists)

• Options: CommaFirst, CommaLast
• Default: CommaFirst

SELECT 
     column1
    ,column2
    ,column3
FROM 
    table

SELECT 
    column1,
    column2,
    column3
FROM 
    table

Condition Break Style

• Options: BreakEachCondition, Inline
• Default: BreakEachCondition
• Description: Controls how WHERE conditions are formatted

WHERE 
    status = 'active'
    AND age > 18
    AND country = 'USA'
				

WHERE status = 'active' AND age > 18 AND country = 'USA'

Logical Operator Placement

• Options: OperatorAtStart, OperatorAtEnd
• Default: OperatorAtStart
• Description: Controls placement of logical operators (AND, OR)

WHERE
    status = 'active'
    AND age > 18
    AND country = 'USA'
				

WHERE 
    status = 'active' AND
    age > 18 AND
    country = 'USA'
				

Condition Indent Level

• Default: 0
• Range: 0 or higher (enforces minimum of 0)
• Description: Indent level for conditions after the first (AND/OR continuation lines)

ON Keyword Placement

• Options: SameLine, NewLine
• Default: SameLine
• Description: Controls whether ON keyword appears on same line as JOIN or on a new line

INNER JOIN orders ON 
    orders.user_id = users.id

INNER JOIN orders
    ON orders.user_id = users.id

JOIN Condition Break Style

• Options: Inline, BreakEachCondition
• Default: BreakEachCondition
• Description: Controls how JOIN ON conditions are formatted
• Example:

INNER JOIN orders ON orders.user_id = users.id
    AND orders.status = 'active'
    AND orders.total > 100

Multiline Function Arguments

• Default: false (single line)
• Description: Break function arguments into multiple lines

CONCAT(firstName, ' ', lastName)

CONCAT(
     firstName
    ,' '
    ,lastName
)

Enable List Formatting

• Default: false
• Description: Enable special formatting for SQL lists
• Applies to: IN clause, CREATE TABLE columns, INSERT VALUES

Items Per Row

• Default: 0 (one item per row)
• Description: Number of items per row in lists. Set to 0 to disable (one per row)
• Example with Items Per Row = 3:

WHERE id IN (1, 2, 3,
             4, 5, 6,
             7, 8, 9)

Recommended Team Settings

For consistent, maintainable SQL code across your team:

When to Format

• Before committing code to version control
• After importing legacy SQL scripts
• When reviewing complex queries
• Before sharing SQL with team members