Ability of tables joining

[M1ha-Shvn]

Hi.
I don't see any way nowadays of joining tables in QuerySets. Is anything planned in this direction?

[ishirav]

I don't have anything planned in this area, the main challenge I think is choosing a syntax for this which is both convenient and flexible enough. Perhaps something like:

qs = Person.objects_in(db).filter(Person.gender == 'F')
qs = qs.join(LEFT_OUTER, Pet, Pet.owner_id == Person.id)

where the join method expects the join type, the model (or queryset?) to join with, and the conditions for joining (the ON expressions).
More thinking is needed to see if this is good enough for more complex cases, such as multiple joins in one query, or a table that is joined with itself.