Proposal for a new database maxim:
A query, originally written to find one row with a particular value, will eventually be rewritten to find multiple rows with a collection of values.
That is, if you had select * where id = ?, that query will eventually be rewritten to select * where id in (…).