/Python/Django/Queryset.raw() in django rest framework joining tables

Queryset.raw() in django rest framework joining tables

class MyModelViewSet(viewsets.ModelViewSet):
    # The usual stuff here
    model = MyModel

    def list(self, request):
        queryset = MyModel.objects.raw('... your SQL here...')
        serializer = MyModelSerializer(queryset, many=True)
        return Response(serializer.data)

Similar codes

0 vote231 views1 answer
Django only certain columns from database
Python Django
0 vote227 views1 answer
Field 'id' expected a number but got <django.db.models.fields.related_descriptors.create_forward_many_to_many_manager.<locals>.ManyRelatedManager object at 0x7fb02044de80>
Python Django
-1 vote222 views3 answers
Raw sql query to django converter
Python Django
2 votes188 views1 answer
Register modal in django admin
Python Django
0 vote196 views1 answer
Django vs code extensions
Python Django
0 vote222 views2 answers
How to get current page url in django template
Python Django
1 vote196 views2 answers
Django url static
Python Django
1 vote214 views1 answer
Passing user instance django form submission
Python Django
2 votes189 views1 answer
Django setup allowed hosts
Python Django
0 vote218 views1 answer
Minimal requirements.txt django
Python Django