Report question

Question: What is a dynamic SQL query, and when would I want to use one?