it doesn't?

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