Earlier quoted context omitted.
It would be good for security but horrible for usability. I recently got an iPhone and had to migrate to it from my Android phone which turned out to be really unpleasant because I could not carry over WhatsApp data. Turns out that the SQLite database is encrypted and I can’t easily carry it over, nor even get the encryption key in a non-rooted device. Furthermore, there is also the issue that Android only backs up t…
FWIW I did manage to decrypt the sqlite database with the encryption key that you create for google drive backups (and should have noted down somewhere). It's been a while, but I think I used this github repo [0], that was the first search result, and it also mentions the 64 character long key. [0] https://github.com/ElDavoo/wa-crypt-tools
If you still have the key and encrypted database, you "only" need to:
1. Have python
2. Install the project like described in the README
3. Execute
wacreatekey --hex
4. Execute wadecrypt encrypted_backup.key msgstore.db.crypt15 msgstore.db