Django - convert RawQuerySet to QuerySet

raw_as_qs.py

from django.db import connection, models
 
class MyManager(Manager):
    def raw_as_qs(self, raw_query, params=()):
        """Execute a raw query and return a QuerySet.  The first column in the
        result set must be the id field for the model.
        :type raw_query: str | unicode
        :type params: tuple[T] | dict[str | unicode, T]
        :rtype: django.db.models.query.QuerySet
        """
        cursor = connection.cursor()
        try:
            cursor.execute(raw_query, params)
            return self.filter(id__in=(x[0] for x in cursor))
        finally:
            cursor.close()
 
 
class MyModel(models.Model):
    objects = MyManager()

This works? I tried but it doesn't seem to work.. Sorry for the previous comments..

So 2 queries are run instead of one? Also, the ordering won't be guaranteed to be the same as the raw query.

Thanks man. Working fine for me 👍

this just filters the current queryset, with the ids from the raw query... does not create a new queryset, with data from raw query...

https://gist.github.com/poppingtonic/792cd601ff9cc4605882865cfb48e1ac

Doesn't work for me as well.

This will kill the DB performance if the number of results is huge (say, hundreds of thousands and more)