[Django] #33535: Add Basic support for DB View

[Django]

#33535: Add Basic support for DB View
-------------------------------------+-------------------------------------
Reporter: Vasanth | Owner: nobody
Type: New | Status: new
feature |
Component: Database | Version: dev
layer (models, ORM) |
Severity: Normal | Keywords: ORM, DB View
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Since Django ORM lends itself to easy data manipulation and query
generation, we can define Managers similar to DB Views. However, it is
simpler to offload complicated Queries critical to the app to the DB.

It allows developers to,

1. Expose denormalised data via APIs (REST and GraphQL).
2. Reuse the virtual tables with third-party applications.

All of Django's officially DBs support DB Views. So basic CR*D support can
be added for DB Views. In addition, abstract functions can be used for
modifying data through views which allows to side-step sqlite not
supporting it.

Non-goals:
1. Support for Materialized views

--
Ticket URL: <https://code.djangoproject.com/ticket/33535>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#33535: Add Basic support for DB View
-------------------------------------+-------------------------------------
Reporter: Vasanth | Owner: nobody

Type: New feature | Status: closed
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution: needsinfo

Keywords: ORM, DB View | Triage Stage:

| Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tim Graham):

* status: new => closed
* resolution: => needsinfo

Comment:

The [https://groups.google.com/g/django-
developers/c/asYZNgJH2_4/m/qo4Q6yiGAQAJ django-developers discussion]
hasn't received much feedback. You'll need to flesh out your proposal and
get a consensus there before we can accept a ticket.

--
Ticket URL: <https://code.djangoproject.com/ticket/33535#comment:1>