[FORMATTING] Unusual formatting of RETURNING clause

Input data

Which SQL and options did you provide as input?

const prettierPluginSqlConfig = {
  language: 'postgresql',
  keywordCase: 'upper',
  // - Wrap all parenthesized expressions to new lines (eg. `INSERT` columns)
  // - Do not wrap foreign keys (eg. `REFERENCES table_name (id)`)
  // - Do not wrap column type expressions (eg. `VARCHAR(255)`)
  expressionWidth: 8,
};

Expected Output

    DELETE FROM example
    WHERE
      id = ${id} 
    RETURNING 
      id,
      firstName,
      lastName

Actual Output

    DELETE FROM example
    WHERE
      id = 1 RETURNING id,
      firstName,
      lastName

Usage

  • How are you calling / using the library?
    Prettier
  • What SQL language(s) does this apply to?
    PostgreSQL
  • Which SQL Formatter version are you using?
    sql-formatter: 12.2.4