Queries across joins are the simple example. The ORM takes care of the join bit for you so you can write:
Book.objects.filter(author__address__country='GB')
Rather than having to manage the joins with the author and address tables yourself.