You’re right, SQLite can be very fast if you know what you’re doing. Expensify was able to achieve 4M queries per second.

https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-q...