Skip to main content

preserveBreaks = breaks_only

breaks_only preserves the user's inter-item line breaks but does NOT auto-detect manual column alignment. This is the middle rung between off (ignore user layout entirely) and breaks_and_alignment (also honor manual padding).

User breaks preserved, no auto-align on aligned AS columns​

User manually padded spaces before AS. Under breaks_only the spacing is normalized (single space before as). Under breaks_and_alignment the padding would be detected and re-emitted as aligned columns.

select
  customer_id       as cust,
  customer_name     as name,
  customer_email    as email
from t
select
    customer_id as cust,
    customer_name as name,
    customer_email as email
from t

Vertical list preserved​

Per-gap SAME_LINE / NEW_LINE signals work identically to breaks_and_alignment.

select a,
  b,
  c from t
select
    a,
    b,
    c
from t

No breaks → same output as off​

With no user newlines to preserve, breaks_only is indistinguishable from off for single-line input.

select a, b, c from t where x > 1
select a, b, c from t where x > 1