Hacker News Reader

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.

That's a good point. This would rule out SQLite for me.

Dynamic SQL isn’t SQL, and it’s not relational. It’s no different from using a language like Python to generate SQL queries.

It's a little different. Anyway, this is under the constraint "no stored procedures."