Issues with Django's QuerySet caching when using Values List for Nested Serializer
I'm facing an issue with Django's ORM when using `values_list()` to retrieve data for a nested serializer. I'm trying to optimize my queries to fetch only the necessary fields, but it seems like the QuerySet is getting cached in a way that causes stale data to be returned on subsequent requests. I'm using Django 3.2.8 and Django REST Framework 3.12.1. My current implementation looks like this: ```python # models.py class Author(models.Model): name = models.CharField(max_length=100) class Book(models.Model): title = models.CharField(max_length=100) author = models.ForeignKey(Author, related_name='books', on_delete=models.CASCADE) ``` ```python # serializers.py from rest_framework import serializers from .models import Book, Author class AuthorSerializer(serializers.ModelSerializer): class Meta: model = Author fields = ['name'] class BookSerializer(serializers.ModelSerializer): author = AuthorSerializer() class Meta: model = Book fields = ['title', 'author'] ``` ```python # views.py from rest_framework import viewsets from .models import Book from .serializers import BookSerializer class BookViewSet(viewsets.ModelViewSet): queryset = Book.objects.all().values_list('title', 'author__name') serializer_class = BookSerializer ``` Initially, the data seems to load correctly, but when the database is updated (e.g., when a new author is added), the changes are not reflected in the API responses. I tried using `.distinct()` and `.iterator()` to see if that would help, but I still end up with the same stale data issue. I've also tried to clear the cache, but that didn't resolve the issue either. Is there a better way to handle this scenario with QuerySets so that my API reflects real-time updates? Any advice would be appreciated!