How to use Postgres stored procedures in Django?

Question

PostgreSQL

Hello! Does anyone know if there is some way to wrap a stored procedure in a Django model?
To make it possible to use paginator, filter (pass parameters to a function) and other joys?
The fact is that the project has statistics that are now calculated through the view, it is wrapped by the model and everything works as it should.
There is a task to make through procedure, there through parameters it is necessary to transfer fields for a filtration.
Or maybe there is some other way?

Answer 1

It will be necessary to call through pure SQL , tk. django will still put the filtering conditions in WHERE, and not in the procedure parameters, and Postgres will not be able to throw them inside (more precisely, if the function is in sql, under certain conditions it can be able to). Yes, and django will not put brackets in the SELECT * from my_proc () call.
And so, you make a function that returns table and should work.

Answer 2

Not sure, but you can try via extra
https://docs.djangoproject.com/en/3.0/ref/models/q...