If you care only about serverless, databases like PlanetScale, CockroachDB Cloud, and DynamoDB work well.

The biggest strength of using SQLite here is that it provides the benefits of a familiar SQL environment with the scaling benefits of Cassandra/DynamoDB.