However, having used Django professionally for a while, I can say that it is really starting to show its age even if you deal with the N+1 problems. You still have to deal with:
1. Blocking database calls that cannot easily be used in an asyncio context
2. No types
3. 50% of package code being written without any regard for performance
If you're starting a project today and considering Django, I highly recommend you go with Nestjs and Prisma instead.