Add OVER(PARTITION BY ...) clause

[enwi]

Why the new feature should be added

Currently for example SQLExpressions.percentileCont(...) only supports .withinGroup().orderBy(...), but not .over().partitionBy(..)

How the new feature should work

It would be awesome to be able to write SQLExpressions.percentileCont(0.25).withinGroup().orderBy("value").over().partitionBy("series") to get PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY value) OVER (PARTITION BY series)

[dodgex]

As there is already support for this with SQLExpressions.count() (e.g. SQLExpressions.count().over().partitionBy((Expression<?>) null)) you could try to do something like this to achieve your percentile count with OVER ()

       new WindowFunction<>(SQLExpressions.percentileCont((Expression<Number>) null))
                .partitionBy((Expression<?>) null);

The nulls of course have to be replaced with your proper Expressions. :)

As an exlanation: SQLExpressions.count() returns a WindowOver instance providing the .over() which then returns a WindowFunction that brings the partitionBy() method.

This is not tested and only assumed to work. But the code gives me good hope, that it should.

[enwi]

Thanks for the reply @dodgex . I will give it a try and report back :)