On the other end you can often build better UI's to reduce the amount of dynamic query building required. Dynamic queries are most heavily needed when you give

On the other end you can often build better UI's to reduce the amount of dynamic query building required. Dynamic queries are most heavily needed when you give users a data table and let them sort/filter as they wish, more often than not this is a complete failure of the UI to understand users workflow and build around it.