Bug: .Bind() is not working properly when selecting specific columns about sqlboiler

[stephenafamo]

Can you turn on boil.DebugMode and share the generated queries for both?

[amangupta25]

These are the generated queries:

1. err = db_models.NewQuery(qm.Select("user.id", "user.name", "user.email_id"), qm.From("user"), qm.InnerJoin("contact ON user.contact_number = contact.contact_number")).Bind(ctx, d.db, &info) :

Generated Query:
SELECT "user"."id" as "user.id", "user"."name" as "user.name", "user"."email_id" as "user.email_id" FROM "user" INNER JOIN contact ON user.contact_number = contact.contact_number;

2. err = queries.Raw(select user.id, user.name, user.email_id from user inner join contact ON user.contact_number = contact.contact_number).Bind(ctx, d.db, &info1) :

Generated Query:
select user.id, user.name, user.email_id from user inner join contact ON user.contact_number = contact.contact_number

[stephenafamo]

The issue is not the Bind the issue is the Join

When there is a join, the columns are aliased because it is assumed that you want to select values from multiple tables.

Try something like this:

type LimitedInfo struct {
    ID      string `boil:"id"`
    Name    string `boil:"name"`
    EmailID string `boil:"email_id"`
}

var info []*Struct{
    LimitedInfo   `boil:"user,bind"`
}


err = db_models.NewQuery(qm.Select("user.id", "user.name", "user.email_id"), qm.From("user"), qm.InnerJoin("contact ON user.contact_number = contact.contact_number")).Bind(ctx, d.db, &info)