There's no real practical way to do this. Hence, I suspect this is what Amazon does. There are companies that do data virtualization, essentially allowing you a PIT view of your system on a rolling basis. A fancy way of PIT restores through log shipping, but giving you a "database" at that PIT. Of course, more of them are in the 6-7 figure range, so I guess magic is expensive.

We could do something, but it's not likely to be commerically viable. What's better is to teach people how to make backups and perform restores and then recover systems. What would be nice in Azure, and maybeSQL Server, is a button that restores a backup + logs, but to a new name, then renames the old and new so that the app can work, but we have a copy of data that we can move as needed.