when use custom select with onQuery relation throw ambiguous error

[farshadfahimi]

I have simple model with custom relation

class Category extends BaseModel {
  @hasManyThrough([() => ProductsCategory, () => CategoriesXref], {
    foreignKey: 'childId',
    throughLocalKey: 'parentId',
    throughForeignKey: 'id',
    onQuery: (builder) =>
      builder
        .select('categories.*', 'categories_xref.sort')
        .whereNot('categories.id', 1)
        .orderBy('sort', 'desc'),
  })
  public parents: HasManyThrough<typeof Category>
}

in this example when remove the select statement it work currectly.

but if you add custom select like above. got error. I can not set table name for throughForeignKey and if I write categories.id take all of that as table name. It should generate query like below

select categories`.*, `categories_xref`.`sort`, `id`, `categories_xref`.`child_id` as `through_child_id` from `categories` inner join `categories_xref` on `categories_xref`.`parent_id` = `categories`.`id` where not `categories`.`id` = 1 and `categories_xref`.`child_id` in (483) and `products_categories`.`deleted_at` is null order by `sort` desc - ER_NON_UNIQ_ERROR: Column 'id' in field list is ambiguous

[thetutlage]

Do you get this error when preloading the relationship?

[thetutlage]

Created an issue from the discussion #3726