Hacker News new | ask | show | jobs
by dventimi 1197 days 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.
2 comments
alphanumeric0 1197 days ago
That's a good point. This would rule out SQLite for me.
link
mr_toad 1197 days ago
Dynamic SQL isn’t SQL, and it’s not relational. It’s no different from using a language like Python to generate SQL queries.
link
dventimi 1196 days ago
It's a little different. Anyway, this is under the constraint "no stored procedures."
link