if you are referring to issues using sqlite as a production database for large-scale web applications, I would remind you of the phrase "horses for courses".
https://sqlite.org/whentouse.html