Have you had experience writing complex queries using Django ORM?

Yes, in Django ORM, you can create complex queries using methods like filter(), annotate(), aggregate(), as well as Q expressions for complex conditions and query unions. For example, you can make a query with multiple conditions and annotations:

from django.db.models import Q, Count

# Get users who have orders with a total greater than 1000 or who registered this year
users = User.objects.filter(
    Q(orders__total__gt=1000) | Q(date_joined__year=2024)
).annotate(order_count=Count('orders'))

This query combines conditions using Q and adds a count of related objects via annotate. Django ORM allows building quite complex queries while remaining convenient and readable.