Osisoft PI supports a relative time literals syntax, e.g.
will select all data between right now and 14 days ago, and
will select all data after yesterday midnight.
The string literals are converted to time values in the PI Server
Running the same queries through teiid however returns incorrect results, because teiid pushes a cast to string on the Time column, which results in string comparison on the datasource: