sqlkata/querybuilder

Is it possible to query temporal tables with "FOR SYSTEM_TIME?"

mdnpascual opened this issue · 1 comments

I've been reading the docs and issues if anyone has tried using the query pattern FOR SYSTEM_TIME FROM <FromDate> TO <ToDate> with no luck

An example query would be:

"SELECT * FROM [sampleTable] FOR SYSTEM_TIME FROM '{fromDate.ToString()}' TO '{toDate.ToString()}' WHERE [sampleColumn] = @p0"

Figured out I can use FromRaw and append the FOR SYSTEM_TIME FROM '{fromDate.ToString()}' TO '{toDate.ToString()}' to convert it to a temporal query