Report question

Question: Is there a standard approach to generating sql dynamically?