django - 原始 INNER JOIN REST 框架

Question

如何在 django rest 框架中使用 django raw，但是使用 INNER join，我有以下序列化

class PcprovinciaSerializer(serializers.ModelSerializer):
    class Meta:
        model = Pcprovincia
        fields ="__all__"

class LolViewSet(viewsets.ModelViewSet):
    queryset = Pcprovincia.objects.all()
    serializer_class = PcprovinciaSerializer
    module = "lol"

    def list(self, request, *args, **kwargs):
       try:
           queryset = self.queryset.raw("SELECT * FROM PCProvincia INNER JOIN PCPais ON idpais=idpais")
           serializer = self.get_serializer(queryset, many=True)
           return Response(serializer.data)
       except Exception as e:
           return Response({"error":str(e)})

它会生成以下错误 错误

如何序列化内部连接？

标签： djangodjango-rest-framework