Archivists also love formats close to native. SQLite lets the relational relationships be present in a way that csv cannot.

That's certainly true. The ability to define table relationships is a major difference from CSV.