With a little extra effort, you can construct a single query that returns multiple rows using the SQL IN operator.
From there, you can convert the query results into a language construct that is easy to work with.
ColdFusion SQL Bulk Insert based on structure keys
I realize this particular requirement might be rare, but it comes in handy when you have an XREF (cross-reference) table which ties two tables together.…