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()

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)