I discovered a similar limit with postgresql, mainly due to the protocol sending the query length as a 16-bit number, limiting the total length to ~65k characters.
In that case it was far better to create a temporary table and JOIN that rather than using an "
IN (..)" clause anyway, so that's another option if SQLite supports it.