
"Many Small Queries Are Efficient In SQLite"
https://www.sqlite.org/np1queryprob.html
in fact, many small queries can be slightly faster than a single, more complex query, based on testing i'm doing on ktistec. the difference is small—10-15 msec for a complex page on average.