Cross join in Django ORM

[nessita]

Hi @snb2013! While I don’t have the answer to your inquiry, this other topic seems related:

generate series & cross join

Hello ! I am trying to generate an initial queryset consisting of a CROSS JOIN between a generated date sequence using Postgres generate_series and another table Foo (resulting in a generated table containing each item of Foo for each date, the cartesian product). I would like to use the Django ORM because I have a lot of post-processing to do after that, with filters, annotations, sub-queries, aggregations, etc. I found a raw SQL answer to a very similar question here: And a library implem…

There are also a few stackoverflow and reddit matches when using a search engine. I hope this helps!