Open
Description
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