Blank-Line Grouping in Lists
The edge cases behind one row of the gap table in Preserve Breaks: an empty
line between two list items is a BLANK_LINE gap, and a BLANK_LINE gap is honored at every tier —
including preserveBreaks: off, because a blank line is meaning rather than layout.
There is no setting for this and no separate mechanism behind it. Read Preserve Breaks for the model; this page is the corners.
Blank-line groups between select items survive
select
k_student,
any_value(tenant_code) as tenant_code,
max(a) as is_title_i_active,
max(b) as is_title_i_annual,
max(c) as part_status
from stage
select
k_student,
any_value(tenant_code) as tenant_code,
max(a) as is_title_i_active,
max(b) as is_title_i_annual,
max(c) as part_status
from stage
A run of blank lines collapses to one
select
a,
b
from t
select
a,
b
from t
A grouped list never collapses onto one line
select a, b,
c from t
select
a,
b,
c
from t
An own-line comment is not a group boundary
select
a,
-- own-line comment
b
from t
select
a,
-- own-line comment
b
from t