[FORMATTING] ClickHouse: ASOF LEFT JOIN and ANY LEFT JOIN are split into two lines #989

Input data

SELECT a FROM t1 ASOF LEFT JOIN t2 ON t1.k = t2.k AND t1.t >= t2.t ANY LEFT JOIN t3 USING (k)

Options: { language: 'clickhouse' }

Expected Output

SELECT
  a
FROM
  t1
  ASOF LEFT JOIN t2 ON t1.k = t2.k
  AND t1.t >= t2.t
  ANY LEFT JOIN t3 USING (k)

Actual Output

SELECT
  a
FROM
  t1 ASOF
  LEFT JOIN t2 ON t1.k = t2.k
  AND t1.t >= t2.t ANY
  LEFT JOIN t3 USING (k)

Usage

• format(sql, { language: 'clickhouse' })
• ClickHouse. The dialect only knows the join strictness after the join type (LEFT ASOF JOIN, LEFT ANY JOIN). ClickHouse also accepts it before the join type and documents it that way: ASOF LEFT JOIN in the ASOF JOIN section, and ANY LEFT JOIN in an example on the same page. So ASOF and ANY are left at the end of the previous line.
• sql-formatter 15.9.0

A fix is in #987.

This was prepared with Claude Code (an AI coding assistant); the outputs above come from sql-formatter 15.9.0.