Skip to main content

CTE Formatting

Control spacing between CTEs in WITH clauses.

Default: blankLineBetweenCtes=false — no extra blank lines between CTEs. On: blankLineBetweenCtes=true — one blank line between each CTE.

Default: no blank lines between CTEs​

with a as (select 1), b as (select 2) select * from a, b
with a as (select 1), b as (select 2) select * from a, b

Blank line between CTEs​

with a as (select 1), b as (select 2) select * from a, b
with a as (select 1), b as (select 2) select * from a, b

Three CTEs with blank lines​

with a as (select 1), b as (select 2), c as (select 3) select * from a, b, c
with a as (select 1), b as (select 2), c as (select 3) select * from a, b, c

Single CTE — no effect​

with a as (select 1) select * from a
with a as (select 1) select * from a