Agreed that Django ORM is one of the better ones, and agree with most limitations you mention.

Oh one final pain points about the Django ORM is how stacking filter/exclude clauses work vs. adding keyword arguments to a single call.

Q objects make this non-awkward and composable. When I was doing Django, I’d typically use filter exclusively and use negated Q objects for exclusions.

score 1 · canonical