fsprojects / SQLProvider

A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
https://fsprojects.github.io/SQLProvider
Other
579 stars 146 forks source link

Support querying MSSQL temporal tables #689

Open Shmew opened 4 years ago

Shmew commented 4 years ago

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?