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

Definition of measurements at the query level #72

Closed Seddryck closed 1 year ago

Seddryck commented 1 year ago

It should be possible to define new measurements at the query level. In the first iteration, only arithmetic expressions should be used and only in column reference projections or aggregation projections

WITH MEASUREMENT Accuracy AS (
    Forecasted - Produced
)

SELECT
    AVG(Accuracy) AS Accuracy
FROM
    WindEneregy