Using WHERE-IN clauses in named queries is difficult when I want to pass a short list of strings into the 'IN' portion of the query. The whole list gets wrapped in quotes rather than each individual element, thus named queries must be constructed very weirdly and rigidly in these cases.

For example, I might want to find all records WHERE Location IN (:office), but if I pass a value of ''North','South'' into the office parameter, the whole string is read rather than each of the 2 offices separately, leading to 0 results. Or if there is some escape character that would be possible here, that could work too.