Dynamic queries

Hi,

What is the recommended way to work with dynamic queries, any optimization techniques, is there a way to avoid them using functions written in MAL.