SQL Formatter Options

Conditions in Brackets

When a WHERE or HAVING clause groups conditions with brackets, the brackets carry the logic: they decide what binds to what. These options make that grouping visible at a glance by placing linebreaks around the brackets and indenting their contents.

Conditions in Brackets

ID	Option	What it does	Default
ID088	ProLinebreak Before '(' LBB_CONDITIONBRACKET	Puts the opening bracket of a condition group on a new line.	`off`
ID017	ProLinebreak After '(' LBA_CONDITIONBRACKET	Starts the first condition on the line after the opening bracket, so the bracket alone marks the beginning of the group.	`on`
ID091	ProLinebreak Before ')' LBB_CLOSECONDITIONBRACKET	Puts the closing bracket on a new line, where it terminates the group.	`off`
ID092	ProLinebreak After ')' LBA_CLOSECONDITIONBRACKET	Starts whatever follows the group on the line after the closing bracket.	`off`
ID069	ProIndent Conditions in Brackets IND_AFT_CONDITIONBR	Indents the conditions inside the brackets one level deeper, so that nesting depth becomes visible as indentation depth.	`on`

Brackets carry the logic of a filter – they decide what binds to what. Indenting their contents makes that grouping visible.

ID017 off, ID069 off

where (dept_nbr = 10 or dept_nbr = 20) and active = 1

ID017 on, ID069 on

where (
          dept_nbr = 10
          or dept_nbr = 20
      )
      and active = 1

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.