I tried to describe my case with custom joins in django issue tracker.
I hope that I described it quite clearly. And that was helpful.
I would especially like to note that
https://stackoverflow.com/questions/22902263/django-orm-joining-subquery/42816689#42816689
this solution completely suited
I'm the one who reported that issue. This is my usecase:
I have a table T like this:
pk: Primary Key (btree indexed)
value: double (btree indexed)
group1_id: Integer (btree indexed)
group2_id: Integer (btree indexed)
...
I'm querying the table for `MIN(pk), ARRAY_AGG(ARRAY(group_id,
Someone has again brought up the lack of custom join support in django -
specifically LEFT OUTER joins: https://code.djangoproject.com/ticket/29262
I figure it's probably something that we'd like the ORM to support but I
don't think we've ever really landed on a design that's palatable. I'd