Separate chain for a different Django example, it only natively supports joins on explicit foreign keys, but because it has that extra information in the model

Separate chain for a different Django example, it only natively supports joins on explicit foreign keys, but because it has that extra information in the model the syntax for using it is extremely compressed. Let's say you have a "Dog" table with a foreign key to "Owner", and "Owner" has a foreign key to "City". Getting all the dogs that live in New York would be: Dog.objects.filter(owner__city__name = 'New York') The double-underscore follows the foreign keys until the last one, which is a field on the last model.