Maybe I’ve never worked a system that let you pre-compile to the inner language of the database. Oracle is a biggie in the business world, though, and I’ve watched what happens internally when you do a full dynamic SQL versus a “precompiled” statement. Even with the latter, hunks of SQL get passed to the parser AT RUN TIME. Sure, the precompiler understood the SQL — well enough to munge it a little and send it on to the parser at run time.
Nossir. I’ve seen my SQL get compiled and run faster.
But more importantly, Dynamic SQL does not work well in such frameworks and Entity Framework. There cannot be any Reflection. That means you cannot get Type Safety, nor can you leverage EF to generate code and classes for you.
Furthermore, D SQL doesn’t lend itself to the performance tools.
D SQL.
Just say no.