vapor/sql-kit

Support the IN operator

grosch opened this issue · 1 comments

grosch commented

Using the SQLSelectBuilder.html it doesn't seem to be possible to do a WHERE xyz IN (1, 2, 3) type filter.

tanner0101 commented

Support for key path + arrays will be added in #35. After this, you'll be able to do something like:

try conn.select().all().from(Planet.self)
    .where(\Planet.type, .in, [.smallRocky, .gasGiant])
    .all(decoding: Planet.self)
    .wait()