[FORMATTING] Parenthesized query starting directly after CTE

[karlhorky]

Input data

Which SQL and options did you provide as input?

WITH a AS (
  SELECT * FROM items
)
(SELECT a.x FROM a) UNION (SELECT b.x FROM b);

Expected Output

WITH
  a AS (
    SELECT
      *
    FROM
      items
  )
(
  SELECT
    a.x
  FROM
    a
)
UNION
(
  SELECT
    b.x
  FROM
    b
);

Actual Output

Parenthesized SELECT a.x FROM a query follows directly after the CTE (and has an extra indent) instead of starting on position 0 of the next line.

WITH
  a AS (
    SELECT
      *
    FROM
      items
  ) (
    SELECT
      a.x
    FROM
      a
  )
UNION
(
  SELECT
    b.x
  FROM
    b
);

Usage

• How are you calling / using the library? Demo website
• What SQL language(s) does this apply to? PostgreSQL
• Which SQL Formatter version are you using? 14.0.0

[nene]

This is one of those bugs that is going to be near-impossible to fix with the current architecture of SQL Formatter.

[karlhorky]

Btw for anyone interested in giving an alternative to sql-formatter a try, prettier-plugin-sql-cst does this correctly:

Input WITH a AS ( SELECT * FROM items ) (SELECT a.x FROM a) UNION (SELECT b.x FROM b);

Formatted WITH a AS ( SELECT * FROM items ) (SELECT a.x FROM a) UNION (SELECT b.x FROM b);

Demo: https://nene.github.io/prettier-sql-playground/