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
27646	Add QuerySet support for group by modifiers and OLAP functionality	Mads Jensen	nobody	"PostgreSQL 9.5 introduced `cube`, `grouping sets` and `rollup`. MySQL/MariaDB supports the `rollup`-operation for aggregations. Oracle (obviously) also supports `rollup`, `grouping sets` and `cube`. I suggest adding methods in `QuerySet` for this, feature-flags to indicate level of support, and either new expressions for the different `rollup`-syntax, or amend the operations of the backends for this. The syntax is slightly different in MySQL/MariaDB, as it uses `WITH ROLLUP`, rather than `ROLLUP`.

https://oracle-base.com/articles/misc/rollup-cube-grouping-functions-and-grouping-sets
http://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
https://www.postgresql.org/docs/current/static/queries-table-expressions.html#QUERIES-GROUPING-SETS"	New feature	new	Database layer (models, ORM)	dev	Normal		olap rollup orm	Adam Johnson Hannes Ljungberg John Speno David Sanders Tilman Koschnick	Accepted	0	0	0	0	0	0