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.
We seem to be talking about two different things in two different database architectures. Oracle kind of fakes it. I’ve watched the traffic between the client processes and the server, and it rips out some pretty plain SQL between the two. Obviously the server is still parsing that stuff.