The list with fixed formatting: * Give up and write a fully dynamic query. * Generate every possible permutation. Combinatorial explosion quickly makes this i

The list with fixed formatting: * Give up and write a fully dynamic query. * Generate every possible permutation. Combinatorial explosion quickly makes this impractical. * Write a static query without the optional clauses, then add clauses and execute a dynamic query. The best of both worlds but complicated.