Have you considered handling for the JOIN "USING" keyword the same as "ON"?
There are newline before and after formatting options for the ON keyword when used in a JOIN clause but not for the increasingly common USING keyword/clause. It also appears that manipulating the USING options under the SQL/"Merge" section had no effect (as I would expect). I think they should be treated the same. e.g., in the SQL/"SELECT" section
☐ ☐ ON Would become ☐ ☐ ON/USING
Consider the generated formatted code below and the Notepad++ settings which result in my JOINs clauses are formatted differently for the same logical equivalent.
- Note that there is no newline after "ON" but is after "USING"
- Not sure why I am getting the two spaces between "(" and "t1.id" but that is a separate topic for a different day.
| Generated Formatted Code | Settings in Notepad++ |
|---|---|
| SELECT * FROM t1 JOIN t2 USING (id) JOIN t3 ON ( t1.id = t2.id) |
 |
