Quick & dirty "read-only" model for using SQL views

models.py

class ViewManager(models.Manager):
    def bulk_create(self, *args, **kwargs):
        raise NotImplementedError

    def create(self, *args, **kwargs):
        raise NotImplementedError

    def get_or_create(self, *args, **kwargs):
        raise NotImplementedError

    def delete(self, *args, **kwargs):
        raise NotImplementedError

    def update(self, *args, **kwargs):
        raise NotImplementedError

class View(models.Model):
    objects = ViewManager()

    class Meta:
        abstract = True
        managed = False

    def delete(self, *args, **kwargs):
        raise NotImplementedError

    def save(self, *args, **kwargs):
        raise NotImplementedError

Maybe you should just use this https://github.com/isotoma/django-postgres. Creating a model view is as simple as:

class Book(models.Model):
title = models.CharField()
author = models.ForeignKey()
class Meta:
db_table = 'Book'
verbose_name_plural = 'Books'

class vBook(pg.View):
projection = [ 'myapp.Book']
sql = MY_RAW_SQL #a pre-defined raw sql

(pardon the horrible comment formatting, but i bet you can get the general idea)
And that's it !