Re: Filtering window expressions. Ticket #28333

2020-04-04 Thread charettes
Hey Mads, I'll start by saying that subquery handling is a bit messy in the ORM. As you noticed there a few tickets and PRs about trying to make it better. I personally tried to get things better by pushing a lot of the current Subquery logic down Query a few months[0] ago but there's still a l

Filtering window expressions. Ticket #28333

2020-04-04 Thread Mads Jensen
Hey, I originally submitted the window functions expressions to Django a couple of years ago for Django 2.0. In hindsight, there are probably things that could be implemented a bit better although I'm not sure how I easily could have used the SQLCompiler or QuerySet/Query classes directly, espe