3 ms·
If you can't use stored procedures which are good for this very case, many databases offer dynamic SQL. That might work in some cases.
by dventimi 4y ago
If you can't use stored procedures which are good for this very case, many databases offer dynamic SQL. That might work in some cases.
- alphanumeric0 4y agoThat's a good point. This would rule out SQLite for me.
- mr_toad 4y agoDynamic SQL isn’t SQL, and it’s not relational. It’s no different from using a language like Python to generate SQL queries.
- dventimi 4y agoIt's a little different. Anyway, this is under the constraint "no stored procedures."