SQL Formatter Options

Analytic Expressions - OVER

Window functions such as ROW_NUMBER() OVER (PARTITION BY … ORDER BY …) pack a whole sub-language into one bracketed expression, frequently inside an already long column list. These options give the OVER clause its own layout so that the partitioning and ordering can be read separately from the function call.

Analytic Expressions - OVER

Brackets

ID	Option	What it does	Default
ID234	ProLinebreak Before '(' LBB_OPENANALYTICBRACKET	Puts the opening bracket of the OVER clause on a new line, separating the window definition from the function call.	`on`
ID235	ProLinebreak After '(' LBA_OPENANALYTICBRACKET	Starts the window definition on the line after the opening bracket.	`on`
ID236	ProLinebreak Before ')' LBB_CLOSEANALYTICBRACKET	Puts the closing bracket on a new line.	`on`
ID237	ProLinebreak After ')' LBA_CLOSEANALYTICBRACKET	Starts whatever follows – usually the alias – on the line after the closing bracket.	`on`

All four off

select rank() over (partition by dept_nbr order by salary desc) as rnk
from   employee

ID234 on, ID235 on, ID236 on

select rank() over
       (
           partition by dept_nbr
           order by salary desc
       ) as rnk
from   employee

PARTITION BY / ORDER BY

ID	Option	What it does	Default
ID240	ProLinebreak Before PARTITION BY, ORDER BY, LBB_ANALYTICPARTITIONBY	Puts each of PARTITION BY, ORDER BY and the frame clause on its own line, which is what makes a complex window definition readable.	`on`
ID241	ProStack Attributes LB_STACKANALYTIC	Stacks the columns of a PARTITION BY or ORDER BY one per line.	`on`

ID240 off, ID241 off

over (partition by dept_nbr, job order by salary desc, hire_date)

ID240 on, ID241 on

over (partition by dept_nbr,
                   job
      order by salary desc,
               hire_date)

Stack & Indenting

ID	Option	What it does	Default
ID238	ProIndent Statement Inside Bracket IND_ANALYTICBRACKETINSIDE	Indents the contents of the OVER bracket one level deeper.	`on`
ID239	ProIndent Brackt IND_ANALYTICBRACKETOUTSIDE	Indents the bracket itself relative to the function call.	`on`

ID238 off

over
(
partition by dept_nbr
order by salary desc
)

ID238 on

over
(
    partition by dept_nbr
    order by salary desc
)

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.