Re: Filtering window expressions. Ticket #28333

2020-04-05 Thread Claude Paroz
Le dimanche 5 avril 2020 00:06:15 UTC+2, charettes a écrit : > This subquery operation would address a few other cases that I know > Claude[3] is interested in seeing addressed as well. Maybe you'd be able to > pair on this problem given his interest in the problem and your past > interactions

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