Non deterministic column binding when same column name across two tables (inner join) about sqlboiler HOT 1 CLOSED

Because of the nature of SQLBoiler's design, this is not possible. You should prefix each of your columns with the table name and bing appropriately: e.g.

type MandateAndUser struct {
	M models.Mandate `boil"mandate,bind"`
	U models.User `boil"user,bind"`
}

SELECT mandate.id as "mandate.id", user.id as "user.id" ...

I understand that writing the query this way is inconvenient, but it is currently the only way to make this work deterministically with the current design.

If you can send in a PR to make your expectation work I will be very happy to review.

from sqlboiler.