SQLboiler not in clause

Question

I am trying to follow the examples in sqlboiler (https://github.com/volatiletech/sqlboiler). But, I can't find a way to get equivalent of NOT IN query.

users, err := models.Users(
  Select("id", "name"),
  Where("age > ?", 30),
  AndIn("c.kind in ?", "visa", "mastercard"),
).All(ctx, db)

In this example, if, we could get an operation AndNotIn, it'd be great.

Thanks!

Answer 1

I'm seeing AndNotIn in current versions of SQLBoiler generated code.

Looks like it was added on July 3rd, 2020.