“SQLite is the most common DBMS in the world, shipped with all popular operating systems.”
SQLite does JSON, CTEs, full-text search and CSV import from one file with no server. People still reach for Postgres for a 10,000 row dataset because SQLite sounds small. The most deployed database on earth doesn’t need to prove it is serious. The engineers dismissing it do.