There is no explicit limit on the number of terms in the RHS of an IN operator. The size will end up being limited by things like: * SQLITE_LIMIT_SQL_LENGTH * SQLITE_LIMIT_VDBE_OP If you have a large number of values in your application program that you want to appear on the RHS of an IN operator, you might be better served to load those values using the [carray()][1] table-valued function. [1]: https://www.sqlite.org/carray.html