rowid treated as ambiguous when user-defined rowid column exists in JOIN

[Pavan-Nambi]

turso> CREATE TABLE a(x TEXT);
CREATE TABLE b(rowid TEXT);
INSERT INTO a VALUES('sku1');
INSERT INTO b VALUES('sku1');
SELECT rowid FROM a JOIN b ON a.x = b.rowid;

  x Parse error: ROWID is ambiguous

turso>

Originally posted by @Pavan-Nambi in #3698