Maximilian Roos

I'm trying to recall whether counting nulls was a deliberate decision or not. It's not specifically discussed in [Null handling](https://prql-lang.org/book/reference/spec/null.html). @aljazerzen do you recall / have a view?

I've been working with python arrays a lot in the past few weeks. If we want a smaller change, one option would be to have a `len` / `length` function...

> 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...

+1 @jangorecki One thing we could start with is "How are PRQL's language semantics different from SQL" — i.e. less focused on the pipeline approach, and more on things like...

Yeah. Possibly we could provide a helper method so that if folks have a `utils.prql` string and want to call functions from that from `foo.prql`, that's easy? Maybe we make...

Ah nice, that is good. > I mean, this is as easy as it gets: You may be underestimating the benefit of nice abstractions :) But I think that's would...

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 the SQL that...

> Just a link to a book that compares this: > https://eitsupi.github.io/querying-with-prql/timeseries#sec-moving-ave These are really great!!

> The written SQL is in the first post, no need to count nulls there, just case row_number(). Yes great, thanks.

Agree, thanks for the report @syko