I don't know about modern state of things, but around 2018 I switched my application from `.dump` to [SQLite Online Backup API](https://sqlite.org/backup.html) because `.dump` apparently didn't preserve [`PRAGMA user_version`](https://sqlite.org/pragma.html#pragma_user_version).