I think you'd be surprised to learn how many real production apps are actually running on top of SQLite (by way of Cloudflare D1).

Many DB servers are built upon embedded DB primitives (like RocksDB), that doesn’t mean the primitives are sufficient on their own.