Add prefetch related support to RawQuerySet

[Adnan Umer]

When using custom raw SQL queries with Django ORM,

• There is no support to prefetch related models to increase performance
• Query results need to be cached manually

[Tim Graham]

Tentatively accepting, although I haven't looked into the history to understand if there's a design reason why it's not implemented. A ​post on django-users suggests that using prefetch_related_objects() (which has since been ​documented as a public API) works.

I'm unchecking "Has patch" as I don't see a patch anywhere. If there's a patch somewhere, please provide a link.

[Adnan Umer]

Here is the link to ​PR that enabled this feature.

[Дилян Палаузов]

Would you mind implementing the same for bulk_create() #28692?

[Adnan Umer]

Replying to Дилян Палаузов:

Would you mind implementing the same for bulk_create() #28692?

Once someone accept the ticket, I'll post commit solution of that. BTW you can temporarily avoid that situation this way

models = ModelA.objects.bulk_create([ModelA(...), ModelA(...), ModelA(...)])
from django.db.models import prefetch_related_objects
prefetch_related_objects(models, 'b')
for m in models:
        print(m.b.description)  # No more extra SELECT query here

[Simon Charette]

Unless __bool__ and __len__ support is required for prefetch_related to work they should be added/tracked in another PR/ticket.

[Adnan Umer]

Replying to Simon Charette:

Unless __bool__ and __len__ support is required for prefetch_related to work they should be added/tracked in another PR/ticket.

Got that. Moving that to separate PR.