Support querying MSSQL temporal tables

Open
#689 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
5/5
Estimated time
Over a week
Newbie friendliness
25/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Stale
Tech stack
fsharp, sql
Domain
databases

Research direction

Start by reviewing SQLProvider's handling of MSSQL queries and the temporal-table statements shown in the issue. Compare support for each FOR SYSTEM_TIME variant and define done as enabling the supported forms or documenting the recommended alternative when they cannot be supported.

Written by the indexing model from the issue text.

Description

enhancement sql server

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?

Dominant language
F#
Stars
627
Forks
147
Avg merge
2h 2m
Merged PRs (30d)
1

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from fsprojects/SQLProvider

All issues in fsprojects/SQLProvider

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.