SQL FORMATTER OPTION: SUBQUERY NEWLINE BEFORE COMPARISON OPERATOR
This format option control whether put a blank line before comparison operator when it follows a subquery.
name: Subquery_Newline_Before_ComparisonOperator, default is false
setting path: subquery -> Linebreak before comparison operator
SELECT c.[Categoryid] AS [categoryid],
c.[Categoryname],
c.[Picture]
FROM [northwind].[dbo].[CATEGORIES] c
WHERE (((( (SELECT Sum([lpa_l1].[Unitsinstock]) AS [lpav_]
FROM (SELECT p.[Categoryid] AS [categoryid],
p.[Unitsonorder]
FROM [northwind].[dbo].[PRODUCTS] p
WHERE (( p.[Categoryid] = c.[Categoryid] ))) [lpa_l1]) > @p2 ))))
After set Subquery_Newline_Before_ComparisonOperator to true, SQL will be formatted like this:
SELECT c.[Categoryid] AS [categoryid],
c.[Categoryname],
c.[Picture]
FROM [northwind].[dbo].[CATEGORIES] c
WHERE (((( (SELECT Sum([lpa_l1].[Unitsinstock]) AS [lpav_]
FROM (SELECT p.[Categoryid] AS [categoryid],
p.[Unitsonorder]
FROM [northwind].[dbo].[PRODUCTS] p
WHERE (( p.[Categoryid] = c.[Categoryid] ))) [lpa_l1])
> @p2 ))))