It gets painful when the SQL gets complicated, like if you're assembling the query dynamically, or if you need to pass in an array-like object. For example, im

It gets painful when the SQL gets complicated, like if you're assembling the query dynamically, or if you need to pass in an array-like object. For example, imagine if you're using a multi-select GUI object as a filter. How do you load in the selected items to filter the result set?