> especially if users are still in the tens of thousands

I've got unit tests over business methods backed by SQLite that say otherwise.

The biggest benefit with SQLite is being able to ship your customers 1 self-contained binary distribution that "just works". Anything beyond this and we are talking about nasty customer-owned database instances or us shipping docker containers and hoping the gigantic abstraction bubble doesnt pop on us.