QuerySet Operations in Python
From the Django cheat sheet · Models & ORM · verified Jul 2026
QuerySet Operations
Database queries with Django ORM
python
# Basic queries
Product.objects.all()
Product.objects.filter(price__lt=100)
Product.objects.get(id=1)
Product.objects.exclude(stock=0)
# Aggregation
from django.db.models import Count, Avg
Product.objects.aggregate(Avg('price'))💡 Use select_related for ForeignKeys
⚡ F expressions avoid race conditions
📌 bulk_create is faster for many records
🔍 Q objects enable complex queries