SQL Formatter Options

Sub-Select & CTE

A subquery or a common table expression is a complete SELECT nested inside another statement. These options decide how that nested statement is set off from its surroundings: how its brackets are placed and whether its body is indented one level deeper or aligned to the opening bracket.

Sub-Select & CTE

Align & Indent Sub-SELECT Statement

ID	Option	What it does	Default
ID255	ProAlign Subquery to Opening Bracket ALI_SELECT2BRACKET	Aligns the body of the subquery to the position of the opening bracket rather than indenting it by a fixed amount. Keeps deeply nested queries from drifting far to the right.	`off`
ID028	ProIndent Sub-SELECT Statement IND_AFT_SELECTBR	Indents the subquery one level deeper than its surroundings, marking it as a nested statement.	`on`

ID028 off

select dept_nbr
from   dept
where  dept_nbr in (
select dept_nbr
from   employee
)

ID028 on

select dept_nbr
from   dept
where  dept_nbr in (
           select dept_nbr
           from   employee
       )

Tip: ID255 aligns the subquery body to the opening bracket instead of indenting it by a fixed amount. In deeply nested queries this keeps the code from drifting far to the right.

Sub-SELECT Brackets

ID	Option	What it does	Default
ID087	ProLinebreak Before Open '(' LBB_SELECTBRACKET	Puts the opening bracket of the subquery on a new line.	`on`
ID016	ProLinebreak After Open '(' LBA_SELECTBRACKET	Starts the subquery on the line after the opening bracket, so the bracket does not share a line with the SELECT.	`on`
ID089	ProLinebreak Before Close ')' LBB_CLOSESELECTBRACKET	Puts the closing bracket on a new line, where it visually terminates the nested block.	`off`
ID090	ProLinebreak After Close ')' LBA_CLOSESELECTBRACKET	Starts whatever follows the subquery – usually an alias – on the line after the closing bracket.	`off`

All four off

where dept_nbr in (select dept_nbr from employee)

ID087 on, ID016 on, ID089 on

where dept_nbr in
(
    select dept_nbr
    from   employee
)

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.