[FORMATTING] Unusual formatting of RETURNING clause, part 2

[bconway]

Input data

Which SQL and options did you provide as input?

From the PostgreSQL 17 UPDATE doc samples:

UPDATE weather SET temp_lo = temp_lo+1, temp_hi = temp_lo+15, prcp = DEFAULT
  WHERE city = 'San Francisco' AND date = '2003-07-03'
  RETURNING temp_lo, temp_hi, prcp;

Expected Output

UPDATE weather
SET
  temp_lo = temp_lo + 1,
  temp_hi = temp_lo + 15,
  prcp = DEFAULT
WHERE
  city = 'San Francisco'
  AND date = '2003-07-03'
RETURNING
  temp_lo,
  temp_hi,
  prcp

Actual Output

UPDATE weather
SET
  temp_lo = temp_lo + 1,
  temp_hi = temp_lo + 15,
  prcp = DEFAULT
WHERE
  city = 'San Francisco'
  AND date = '2003-07-03' RETURNING temp_lo,
  temp_hi,
  prcp

Usage

• How are you calling / using the library? https://sql-formatter-org.github.io/sql-formatter/
• What SQL language(s) does this apply to? SQL
• Which SQL Formatter version are you using? https://sql-formatter-org.github.io/sql-formatter/

Previous bug here: #678

Thanks.

[nene]

Just select PostgreSQL as the language when formatting.

[pigulla]

I'm seeing the same behaviour with sqlite (according to the docs, RETURNING has been supported since 2021):

[nene]

Better to always open a new issue instead of commenting on an old closed one. Not all SQL dialects support the RETURNING clause - this issue was about PostgreSQL.

Fixed it in SQLite.

[nene]

Released in v15.6.7