Restoring data from a backup, esp. with linked rows, has so many case-by-case nuances, I really haven’t tried to write a general procedure. But at least you can have an off-line backup of your data, to refer to. Just do the backup before you make big changes.
Also search the Forum for other backup routines. IIRC, a newer one backs up to JSON, instead of SQLite.