Django templates are deliberately bad at being a query language. That is a feature, not a missing capability. If a template decides which rows to load, applies business rules, and then walks relationships one item at a time, the result is difficult to test and surprisingly easy to turn into …