Cockroach only.

You can use as_of clause with the following queries:

To retrieve historical data from 5 minutes ago:

await == 'Pythonistas'

This generates an AS OF SYSTEM TIME clause. See documentation.

This clause accepts a wide variety of time and interval string formats.

This is very useful for performance, as it will reduce transaction contention across a cluster.