There always seems to be a need for dynamic SQL, but security seems too limit where it can be used. I found the article and it seemed very intriguing, but have not been able to deeply look into it, so I’m going to put it here for future reading.
"Running a Dynamic Query against SQL Server without using Dynamic SQL"
BarDev - Archive 