CREATE TABLE A (a_id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE B (a_id INTEGER UNIQUE REFERENCES A(a_id), count INTEGER);
SELECT B.a_id
FROM A
JOIN B b ON b.a_id = A.a_id;
Resolving the alias is hard coded in InsertStmtMixin and not reusable for JoinClauseMixin or dialect authors.