Re: Filterable subqueries ...

2019-03-14 Thread charettes
Hey Bern, > And there seems no way in Django currently to do such a simple breakout SELECT wrapper with Subqueries that I can find. Right, there's no public API to perform the pushdown but what you are looking for is really similar to what QuerySet.aggregate() (through sql.query.Query.get_aggr

Re: Filterable subqueries ...

2019-03-14 Thread Bernd Wechner
Josh, Thanks very much for your contribution. Yes it is not concise, but I did hope it is clear. Alas there is a contest between a well presented, well researched, and complete question and a concise one. Sometimes the two don't reconcile themselves well I admit. Your supposition is almost rig

Re: Filterable subqueries ...

2019-03-12 Thread Josh Smeaton
With regard to the stunning silence you're witnessing, it's my guess that you haven't made yourself clear enough in a concise way. The stackoverflow post is large, and doesn't point out what's missing very clearly. What is the SQL you want? What is the SQL you're getting, and what is the querys

Filterable subqueries ...

2019-02-28 Thread Bernd Wechner
I have a problem I've only been able to solvewhich bugs me. I've posted on the Django users list (to stunning silence) and on stackoverflow: https://stackoverflow.com/questions/54388936/using-django-window-functions-on-a-filtered-queryset to comparable silence. I'm rather convinced this can't b