SQL Formatter Options

JOIN

Formatting for JOIN clauses and their ON conditions. Because a query with five joins is mostly join syntax, these options have a disproportionate effect on how quickly a reader can see which tables are combined and on which columns.

JOIN

JOIN Statement

ID	Option	What it does	Default
ID063	ProLinebreak Before JOIN LBB_JOIN	Puts the JOIN keyword on a new line, so that each joined table starts its own block.	`on`
ID146	ProLinebreak After JOIN LBA_JOIN	Starts the table name on the line after the JOIN keyword. With `LEFT OUTER JOIN` this separates the join type from the table.	`on`
ID068	ProIndent JOIN Statement IND_JOIN	Indents the whole JOIN clause one level deeper than FROM, subordinating the joined tables to the driving table.	`off`

ID063 off, ID146 off

from dept inner join employee on dept.dept_nbr = employee.dept_nbr

ID063 on, ID146 on

from dept
inner join
    employee
on dept.dept_nbr = employee.dept_nbr

ON Condition

ID	Option	What it does	Default
ID062	ProLinebreak Before ON LBB_JOIN_ON	Puts ON on a new line, separating the join condition from the table name.	`on`
ID147	ProLinebreak After ON LBA_JOIN_ON	Starts the join condition on the line after ON.	`on`
ID131	ProIndent ON Condition IND_JOINON	Indents the ON condition one level deeper than the JOIN keyword.	`off`

ID062 off, ID147 off

inner join employee on dept.dept_nbr = employee.dept_nbr

ID062 on, ID147 on

inner join employee
on
    dept.dept_nbr = employee.dept_nbr

JOIN Condition

ID	Option	What it does	Default
ID178	ProLinebreak Before AND/OR in JOIN Condition LBB_JOINON_AND	Starts each additional join condition on its own line, led by AND or OR. Essential for composite keys.	`on`
ID179	ProLinebreak After AND/OR in JOIN Condition LBA_JOINON_AND	Puts the condition on the line after the operator.	`off`
ID180	ProIndent AND/OR in JOIN Condition IND_JOINON_AND	Indents the AND / OR operators of a multi-part join condition one level deeper.	`off`
ID156	ProAlign AND/OR to ON ALI_JOINON_AND_TO_ON	Aligns the AND / OR operators of the join condition with the ON keyword, so that ON and its continuations form one column. Only takes effect when both ID062 and ID147 are off – if ON already gets a linebreak before or after it, there is no column to align to.	`off`

ID156 aligns the continuation operators with the ON keyword, so a composite key reads as one block. It requires ID062 and ID147 to be off, as shown here.

ID178 off

on dept.dept_nbr = emp.dept_nbr and dept.region = emp.region

ID178 on, ID156 on

on  dept.dept_nbr = emp.dept_nbr
and dept.region   = emp.region

Tip: If ON has a linebreak before or after it (ID062 / ID147, both on by default), ID156 is ignored – the formatter has no ON on the same line to align against.

Option IDs are identical across all SQLinForm editions (VS Code, JetBrains, SSMS, Notepad++, Online Formatter) and are the keys stored inside a profile file. Generated from properties.json 2026.8.21.0.