Multiple value where clause using squirrel

[AshishMittal02]

I'm trying to recreate this query with squirrel:

SELECT c.userID, c.name, o.orderID FROM users as c join order as o
    ON c.userID = o.userID where orderID IN ('a', 'b');

The closest I can come up with is this and it's wrong:

query := sq.Select("c.id, c.name, o.orderID").
	From("users").join("order as o using (userID)")
	Where(sq.Eq{
		"id": []string{'a', 'b'},
	})

[AshishMittal02]

One option is there to have multiple Where(sq.Eq{} but if i have 100 orderIDs it will grow alot and i think it will be ugly

[ysomad]

you can use squirrel.And