rate(metric[5m]) equivalent in SQL ?

[hvisage]

have a table with several monotonically increasing counter values (gets reset every reboot) and I'm looking for a rate example in SQL the TimeScaleDB equivalent is rate(counter_agg(ts,counterColumn))
It seems that I'll need to setup some flow tasks and sing DB, but don't see an example in the documentatoin

[sunng87]

In GreptimeDB, we have a TQL variant of SQL that you can run promql with SQL interface, with all PromQL functions available: https://docs.greptime.com/reference/sql/tql/