PostgreSQL

Interesting fact:

WHERE field = ANY(ARRAY[...]) may usually perform better than WHERE field IN (...) in PostgreSQL for a large enough list.

stackrlabs.xyz // software dev interested in dev tools, threat intel, chain analysis, MEV // coordination, public goods, game theory // zkcat_eth.twitter

I've had to do this as well. Do you recall why exactly this is?

At least when it comes to prepared statements, the ANY form can pass the array as a single parameter for a variable number of items, whereas IN requires a different prepared statement for each number of items (since each item is a separate parameter).