Yes with the normal queries the IN requires an array but with the custom queries it is a different case.
@patrick should check it out as to see if we support the IN fully.
It should be handled like any other PDO parameter, for example:
https://stackoverflow.com/questions/920353/can-i-bind-an-array-to-an-in-condition