What do you do if you have a highly dynamic query?

[slifin]

For example I have a form where the user can select many different filters, and orderings

In aggregate those options would cause a massive multiplication of the amount of possible queries, is there some kind of composition possible?

I.e. each condition has its own SQL in the file then that can be appended at runtime

Or any support for sub queries where a piece of SQL needs to be substituted into the middle of a query