>>>I could use IS, but apparently that has its own problems, are there any other options?
>>
>>It's hard to answer your question w/o knowing what you're doing. :)
>
>Array of primary keys needs to return array of BusinessObject, so rather than fire off say, a 1000 individual SELECTs I want to execute the entire query in one swoop to improve performance.

Check Re: Variable IN Message #834232 for some generic ways to handle keys list in a query.
You may also try to combine UNION with IN. Say, create a separate select with IN for each nnn keys and join them with UNION ALL.