Create postgresql view in django

Question

I want to use postgresql view to store intermediate result of queryset in django.

Is there a good way to create a view in django?

Below is the code of the flow I want!

elements = Element.objects.filter(is_active=True, eventcardad__isnull=False)

# save elements to database view

# reuse the query results by using view

Answer 1

You can use raw SQL query to do that read this page first.