Checkout "as of" a specific time

[rabernat]

Some users may want the ability to "audit" the state of their data at a particular time in the past. To support this, we should implement the following syntax:

repo.checkout(branch="main", asof=datetime(2024, 11, 2))

This would be implemented by filtering snapshots based on time to find the correct snapshot ID.

[paraseba]

There is also #273 , I'd like to have something like repo.checkout("main~4").

[rabernat]

Here's how this works in SQL with Delta tables: https://docs.delta.io/latest/delta-batch.html#sql-as-of-syntax