Scenario
Data enrichment via a DB lookup may use a SQL "IN" clause, but sometimes the number of values in the IN clause exceeds the number of values allowed in a single IN clause by the database. In that case, it becomes necessary to break up the values in the IN clause into separate blocks so that the database can process them.
...