You mean when the database is well indexed? Yes. SQLite supports Full Text Search (https://sqlite.org/fts5.html) which builds all the indexes for you, allowing you to perform search-engine-like functionality.

But you're right, it does require more attention towards index construction for site owners.