Parser for filters on TIMESTAMP

Seddryck / Tseesecake

Tseesecake is a lightweight proxy for time-series query engines, supporting multiple database engines and storage providers, with a SQL dialect dedicated to time series

https://seddryck.github.io/Tseesecake

Apache License 2.0

2 stars 1 forks source link

Parser for filters on TIMESTAMP #39

Closed Seddryck closed 1 year ago

Seddryck commented 1 year ago

It should be possible to write queries such as

SELECT
    Forecasted
FROM
    WindEnergy
WHERE
    Instant AFTER TIMESTAMP '2023-06-01'

List of the predicates:

[ ] after: Timestamp column compared to Timestamp constant
[ ] before: Timestamp column compared to Timestamp constant
[ ] between: Timestamp column compared to two Timestamp constants
[ ] since: Timestamp column compared to Interval constant