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"