Incorrect indentation in PostgreSQL DELETE FROM ... USING

[karlhorky]

Describe the Feature

More consistent formatting for multiple joined tables after the USING keyword in a DELETE FROM ... USING query (consistent compared to SELECT ... FROM ... JOIN:

Input data

Which SQL and options did you provide as input?

DELETE FROM films
USING
  producers,
  sessions
WHERE sessions.id = '123' AND producer_id = producers.id AND producers.name = 'foo';

Expected Output

DELETE FROM
  films
  USING
    producers,
    sessions
WHERE
  sessions.id = '123'
  AND producer_id = producers.id
  AND producers.name = 'foo';

Actual Output

DELETE FROM films USING producers,
sessions
WHERE
  sessions.id = '123'
  AND producer_id = producers.id
  AND producers.name = 'foo';

Why do you want this feature?

To be more consistent with the SELECT ... FROM ... JOIN formatting:

SELECT
  *
FROM
  candidates
  INNER JOIN sessions ON users.session_id = sessions.id

[nene]

I see this more as a bug report than a feature request.

Unfortunately I have no real ideas for fixing this. It's again one of those bugs that demonstrates the current technical limitations of the formatter.

At least this bug doesn't break the SQL.