Bad query practices are always going to bite you eventually. I would not call that a shortcoming of this approach
It's not a bad query practice in SQLite! https://www.sqlite.org/np1queryprob.html
It's not a bad query practice in SQLite! https://www.sqlite.org/np1queryprob.html