id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
33535	Add Basic support for DB View	Vasanth	nobody	"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
"	New feature	closed	Database layer (models, ORM)	dev	Normal	needsinfo	ORM, DB View		Unreviewed	0	0	0	0	0	0