[Django] #28919: Add support for Common Table Expression (CTE) queries

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel | Owner: nobody
Miller |
Type: New | Status: new
feature |
Component: Database | Version: 2.0
layer (models, ORM) |
Severity: Normal | Keywords: QuerySet.extra
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
[http://django-cte-trees.readthedocs.io/en/latest/ django-cte-trees] (also
[https://github.com/matthiask/django-cte-forest django-cte-forest])
provides specialized uses of CTE queries for managing hierarchical data
with recursive queries. To accomplish this, it uses the `QuerySet.extra()`
API. This is my specific use case for CTE queries at the moment, however
it leverages only one small part of what is possible with CTE queries:
[https://www.postgresql.org/docs/9.6/static/queries-with.html PostgreSQL],
[https://dev.mysql.com/doc/refman/8.0/en/with.html MySQL],
[https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-
expression-transact-sql SQL Server].

Another implementation supporting more general uses of CTE queries was
[https://groups.google.com/forum/#!topic/django-developers/b370mxfKCHg
presented on the developers mailing list], although I'm not sure it has
ever made it any further than that. The code can be found
[https://github.com/django/django/compare/master...ashleywaite:cte-dev on
github]. It appears to do its magic by mutating `base_query.extra_tables`,
which seems to be a private/internal part of the ORM.

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

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0

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

Changes (by Tim Graham):

* version: 2.0 => master
* stage: Unreviewed => Accepted

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

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Comment (by Matthew Pava):

I have the same issue. I've been thinking about this and wondering if
maybe we could just convert the Subquery object into a CTE (common table
expression). They ought to work just the same, and it really shouldn't
break backwards compatibility. At the same time, we could add a kwarg
to the Subquery object, `recursive`, so that we can create a recursive
CTE.

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:2>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Comment (by ErikW):

I like Matthew's idea of reusing Subquery as the basis for CTEs since
behind the scenes CTEs are really just syntactic sugar for Subqueries.
I'd just like to add that being able to pull multiple values/aggregates
from the Subquery/CTE would really push this over the top as a huge
performance boost for complex analytical queries.

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:3>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Matthew Pava):

* cc: Matthew Pava (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:4>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Comment (by Daniel Miller):

I implemented generic CTE support for Django: https://github.com/dimagi
/django-cte

Would be happy to contribute this to be included with Django. Feedback is
welcome.

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:5>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Tyson Clugg):

* cc: Tyson Clugg (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:6>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Comment (by pwfff):

Replying to [comment:5 Daniel Miller]:

> I implemented generic CTE support for Django: https://github.com/dimagi
/django-cte
>
> Would be happy to contribute this to be included with Django. Feedback
is welcome.

This has worked well for me, with the one exception of not being able to
do an outer join since the library just uses extra_tables.

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:7>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Comment (by pwfff):

I have a PR here, but it's incomplete in some ways:
https://github.com/dimagi/django-cte/pull/1
I could use some help from someone more familiar with the Query object and
how it handles joins/aliases.

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:8>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Comment (by Daniel Miller):

It's now been refactored to not use `extra_tables`, and there is a secret
(undocumented, experimental API) way to do a left outer join.

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:9>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Matthew Schinckel):

* cc: Matthew Schinckel (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:10>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Ole Laursen):

* cc: Ole Laursen (added)

Comment:

Daniel Miller: Can I humbly suggest you raise this on django-developers? I
would guess this needs a discussion of the actual API for adding the table
expressions and joining with them.

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:11>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Comment (by Daniel Miller):

Ole Laursen: that's a good idea. I'm a bit busy with other work right now,
but I'll add it to my backlog.

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:12>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Ian Foote):

* cc: Ian Foote (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:13>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Carlton Gibson):

* cc: Carlton Gibson (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:14>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by TZanke):

* cc: TZanke (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:15>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Keryn Knight):

* cc: Keryn Knight (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:16>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Comment (by Javier Buzzi):

Bump.

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:17>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Comment (by Javier Buzzi):

Any updates?

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:18>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Comment (by felixxm):

Javier, patch is welcome. Leaving comments doesn't change anything and is
not helpful.

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:19>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Moses Mugisha):

* owner: nobody => Moses Mugisha
* status: new => assigned

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:20>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Timothy Schilling):

* cc: Timothy Schilling (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:21>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Ryan Hiebert):

* cc: Ryan Hiebert (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:22>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Markus Zapke-Gründemann):

* cc: Markus Zapke-Gründemann (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:23>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Hannes Ljungberg):

* cc: Hannes Ljungberg (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:25>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------

Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned

Component: Database layer | Version: dev

(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Jameel A.):

* cc: Jameel A. (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:27>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Paolo Melchiorre):

* cc: Paolo Melchiorre (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:28>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Krzysztof Szularz):

* cc: Krzysztof Szularz (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:29>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by crypted):

* cc: crypted (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:30>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by John Speno):

* cc: John Speno (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:31>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Julien Palard):

* cc: Julien Palard (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:32>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Dave Johansen):

* cc: Dave Johansen (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:33>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Peter Lithammer):

* cc: Peter Lithammer (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:34>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Fabio Caritas Barrionuevo da Luz):

* cc: Fabio Caritas Barrionuevo da Luz (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:35>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Sébastien Corbin):

* cc: Sébastien Corbin (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:36>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Eron Lloyd):

* cc: Eron Lloyd (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:37>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Peter Thomassen):

* cc: Peter Thomassen (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:38>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tom Carrick):

* cc: Tom Carrick (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:39>

[Django]

#28919: Add support for Common Table Expression (CTE) queries
-------------------------------------+-------------------------------------
Reporter: Daniel Miller | Owner: Moses
| Mugisha
Type: New feature | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: QuerySet.extra | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Dmytro Litvinov):

* cc: Dmytro Litvinov (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/28919#comment:40>