Feature Request: Option to adjust CURRENT_TIMESTAMP when using snapshots

[ryanschneider]

When time travelling, it'd be great if we had the option to change the value of CURRENT_TIMESTAMP and NOW() to the snapshot timestamp. This would allow "floating" queries like WHERE order_date >= CURRENT_TIMESTAMP - INTERVAL '30 days' to "just work" as the snapshot was adjusted. Alternatively there could be a new function or keyword (e.g. reuse SNAPSHOT_TIME) with these semantics.