[v6] Ambiguous on preload with Related Model

[gabrielbuzziv]

I want to preload a hasMany relation and at this preload join with another table to specify the results i need, but since i have a common column between those queries i'm taking ambiguous, but the problema is that i can't set the table name at the preload.

My Question Model Relationship

@hasMany(() => QuestionAlternative, {
    localKey: 'id',
    foreignKey: 'question_id',
  })
  declare alternatives: HasMany<typeof QuestionAlternative>

My Query

const query = Question.query().preload('alternatives', (alternatives) =>
  alternatives.join('question_answers', 'question_answers.alternative_id', 'alternatives.id')
)

The generated SQL

SELECT * FROM "question_alternatives" 
INNER JOIN "question_answers" ON "question_answers"."alternative_id" = "alternatives"."id" 
WHERE "question_id" IN (?, ?, ?)

Look that the preload is generating this where "question_id" IN () automatically but not adding the table name and we can't control it.