Erik Darling points out several use cases for dynamic SQL:
If you have a Swiss Army Knife, pull it out. Open up all the doodads. Now try to do one thing with it.
If you didn’t end up with a corkscrew in your eye, I’m impressed.
I don’t know how Erik found out one of my irrational fears.