You should probably read [](https://www.sqlite.org/np1queryprob.html) though. WHERE-IN is essential in client-server RDBMSs, to send all IDs across the wire in one network-trip, and get all results (or chunks of them via Oracle's row prefetching setting) in as few network-trips as possible as well. But because SQLite is embedded, individual queries are just as fast. So instead of 1x `WHERE col in (:1, ..., :N)` using Nx `WHERE col = :1` (which is a single prepared query) is simpler and probably just fast or faster.