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,Accepted,0,0,0,0,0,0