On Tue, Feb 4, 2020, 5:23 PM J. King <jk...@jkingweb.ca> wrote > Not everyone has access to carrays and intarrays, either, such as PHP > users like myself. >
But everyone has access to temp tables, and I think the idea of creating a temp table, inserting 1000 items in a loop, and using that temp table in the query, is a lot more clear than formatting a query as a string with ?1000 or more bound parameters. It is more idiomatic SQL, I would think. > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users