and yes that's correct, there is some use of

IN

clauses in the query statements and I agree that with large lists that can become problematic