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