Custom SQL query brakes the action

[Teodor]

You can’t just use IN {{array}} in a custom query, as it works differently than inside the query builder.
Please check:

GET array for use with IN clause of custom query action

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