Temporal queries are defined in the SQL:2011 standard

The following query will return the values of the requested customer as they were stored on 2014-03-01

SELECT *
FROM customers FOR SYSTEM_TIME AS OF '2014-03-01' 
WHERE id = 42;

Back to the SQL Feature Comparison