SQLProvider icon indicating copy to clipboard operation
SQLProvider copied to clipboard

Support querying MSSQL temporal tables

Open Shmew opened this issue 5 years ago • 0 comments
trafficstars

It doesn't look like it's currently supported, but with MSSQL you can query temporal tables with statements like this:

SELECT SomeCol
FROM dbo.MyTable

// different variants:

FOR SYSTEM_TIME ALL;

FOR SYSTEM_TIME AS OF '2020-09-04 12:00:00';

FOR SYSTEM_TIME FROM '2020-09-04 12:00:00' TO '2020-09-04 23:59:00';

FOR SYSTEM_TIME BETWEEN '2020-09-04 12:00:00' AND '2020-09-04 23:59:00';

FOR SYSTEM_TIME CONTAINED IN ('2020-09-04 12:00:00', '2020-09-04 23:59:00');

Is this something easily supported? If not, what's recommended?

Shmew avatar Sep 05 '20 05:09 Shmew