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.

Agreed. As usual one has to be careful of absolutes, and there are often circumstances where certain techniques are not appropriate.

Michael