I am happy to report that this has been (recently) solved:
https://www.stavros.io/posts/holy-grail-backups/
"(the) holy grail of backups"