Describe the bug
At the moment window functions can't be mixed with regular expressions.
For instance, the following sql returns Window function expected error:
CREATE TABLE 'weather' (
timestamp TIMESTAMP,
windDir INT,
windSpeed INT,
windGust INT,
) timestamp (timestamp);
select windSpeed, 1-first_Value(windSpeed) over (rows between 1 preceding and current row) as prev
from weather
To reproduce
No response
Expected Behavior
No response
Environment
- **QuestDB version**:7.3.6-SNAPSHOT
- **OS**:
- **Browser**:
Additional context
No response