Tastypie & raw sql

Question

How do I get Tastypie to fetch a raw sql queryset? queryset = Foo.objects.raw(sql) does not seem to be working. Is it not possible?

Answer 1

This seems to work:

class BarResource(ModelResource):

    class Meta:
        queryset = Bar.objects.all()

    def dehydrate(self, bundle):
        qs = Bar.objects.raw('SELECT * FROM foo_bar')
        return [row for row in qs]