Re:The Curse and Blessings of Dynamic SQL
by justinclift on Tuesday May 09, 2023 @05:12AM
(#35871794)
Yeah. This is a definite problem when working with user generated databases (eg untrusted), that could have pretty much anything in them. :/
Re:The Curse and Blessings of Dynamic SQL
by marcosdumay on Tuesday May 09, 2023 @12:05PM
(#35876447)
That, and the lack of functions with a varying number of parameters, and lack of type polymorphism, and of easy to construct local views, and the lack of sum types...
Dynamic SQL is used on practice to fix a lot of problems the SQL people have been refusing to touch.
I am perfectly able to:
But I cannot: I really don't understand why that capability wasn't added a decade ago, as loud as the advice is to avoid hard parsing.