[Solved]-Is it possible to add SQL comments to a query built with the ORM?


For those reading in 2022 onwards – there is a much better answer these days:

Google’s sqlcommenter project has a Django middleware

[A] Django middleware whose purpose is to augment a SQL statement right before execution, with information about the controller and user code to help with later making database optimization decisions, after those statements are examined from the database server’s logs.


Solution found by using .extra() for raw SQL commands on the django-user mailinglist:

Object.objects.filter(Q(pub_date__lte=datetime.now()).extra(where=['1=1 /* query no. 123 */'])

Leave a comment