Multiple joins with USING and the same column id clause compilation error

[sebek64]

SQLDelight Version

2.0.0

Operating System

Linux

Gradle Version

8.4

Kotlin Version

1.9.10

Dialect

sqlite-3-38

AGP Version

No response

Describe the Bug

This code

CREATE TABLE A(
    id INTEGER PRIMARY KEY NOT NULL
);

CREATE TABLE B(
    id INTEGER PRIMARY KEY NOT NULL
);

CREATE TABLE C(
    id INTEGER PRIMARY KEY NOT NULL
);

selectWithJoin:
SELECT *
FROM A
JOIN B USING (id)
JOIN C USING (id);  

causes

Multiple columns found with name id
6    SELECT *
7    FROM A
8    JOIN B USING (id)
9    JOIN C USING (id)
                   ^^

However, the same query run directly on sqlite without issues.

Stacktrace

No response

Gradle Build Script

No response

[griffio]

Likely fix will have to be done in sql-psi
✖️ Previous related issues for multiple columns found with name...
AlecKazakova/sql-psi#560
AlecKazakova/sql-psi#145