eg:

model.query().innerJoinRelation('model2')

would overwrite model's id column with model2's id column as not specifying .select() defaults to '*', no ambiguous column warning is given (using mysql 5.7 with mysql2 as adapter)