For me the big sell is never needing to deal with massive DB version upgrades to get new features. It’s zero maintenance.

The SQLite DB file format has been backwards-compatible for decades. Update the client and that’s it—you’re using the newest version.