[rco8786]

Bad query practices are always going to bite you eventually. I would not call that a shortcoming of this approach

[laurencerowe]

It's not a bad query practice in SQLite! https://www.sqlite.org/np1queryprob.html