Bad number of fields generated when auto-collecting fields in select().from(...) with JOIN .. USING (...) or NATURAL JOIN

[lukaseder]

jOOQ's select() or selectFrom() selects all fields available form the from() clause.

Most SQL dialects report "special" field behaviour, when using JOIN .. USING (...) or NATURAL JOIN clauses. In those cases, the join columns will no longer be associated with their "left" or "right" tables, but they're listed standalone as such:

SELECT * FROM A JOIN B USING (X, Y);

X | Y | A.A1 | A.A2 | B.B1 | ... |
-----------------------------------