If you are offering an interface that allows complex user-defined queries, then not dynamically generating the SQL would mean pre-defining the exploded combination of all possible queries.

I suppose this could be done programatically, but it's often easier to simply dynamically generate the SQL.