sqlccl: strategy for disasters that have happened since the last backup

[danhhz]

We've had a request for the ability to restore a table that has been dropped since the last backup. (Similarly for data changed due to user error.) If the last backup was 10 hours ago and the event happened 1 hour ago, the 9 hours of data since the backup should be recovered, if possible.

Perhaps this is as simple as using DistSQL to SELECT AS OF SYSTEM TIME and INSERT.

[vivekmenezes]

is this the same as #16161

[danhhz]

Sort of. This is the thing we're now calling REVERT, which resets a table to look like it did at some previous point after the gc threshold. My read of #16161 is that it's both REVERT plus the ability to use AS OF SYSTEM TIME with RESTORE (which is something we could do in the future but I don't know if we have an issue for).

[danhhz]

Looks like #16161 got retitled to make this more or less a dup. Closing