Jan Gorecki

count * will cover what length array would do. It includes nulls always, on the other hand count col never includes nulls. Not sure if it make sense to include...

It's not perfect, but that's how SQL settled don't this behavior and there is no inconsistency there, it is just not completely intuitive. If we don't follow SQL it will...

Agree, if diverting from SQL then error would be nice, so there is no way for unexpected results to sneak in. Another way that could be incorporated is to create...

Related discussion in duckdb can be found here: https://github.com/duckdb/duckdb/discussions/8340 In case duckdb will provide option for that, then pqrl compiler could for this target use new duckdb option

Your example won't exactly give what was requested in the question because it filter out rows having partial window. Question asked to just have SMA10 value NULL but still keep...

> I think the request is for something similar to [pandas' `min_periods`](https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.rolling.html), is that correct? > > To develop this, the first thing to do would be to write out...

I am aware if any, and postgres requires table alias prefix to star, star alone won't work.

Considering very limited installation options available now (i do not use vs, i do not want to install npm, i do not need dbt) it is surprising that docker images...

I pushed workaround for this issue in #1904: - creating sequence - editing CREATE TABLE statement to include default value sequence nextval

If we don't want to support duckdb+autoincrement, then it is best to raise error early.