If its a simple query, say only a few lines then you can easily argue the point that dynamic SQL could be simpler than static SQL to maintain. For example in Case 1 of this article the dynamic SQL looks like it is less code and therefore easier to maintain than the static SQL that does the same thing.

However, most dynamic SQL I have seen is long and not simple to read and can require extra time to debug and modify.

Robert Marda