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

Django

unread,

Dec 12, 2017, 4:18:28 PM12/12/17

to django-...@googlegroups.com

#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

unread,

Dec 12, 2017, 10:02:17 PM12/12/17

to django-...@googlegroups.com

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

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

unread,

Dec 18, 2017, 11:09:51 AM12/18/17

to django-...@googlegroups.com

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

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

unread,

Jan 16, 2018, 12:57:02 AM1/16/18

to django-...@googlegroups.com

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

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

unread,

Jan 24, 2018, 5:39:31 PM1/24/18

to django-...@googlegroups.com

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

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

unread,

Feb 26, 2018, 4:31:34 PM2/26/18

to django-...@googlegroups.com

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

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

unread,

Mar 8, 2018, 5:24:13 AM3/8/18

to django-...@googlegroups.com

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

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

unread,

Mar 26, 2018, 9:47:41 AM3/26/18

to django-...@googlegroups.com

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

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

unread,

Mar 28, 2018, 2:12:02 PM3/28/18

to django-...@googlegroups.com

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

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

unread,

Apr 18, 2018, 11:11:49 AM4/18/18

to django-...@googlegroups.com

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

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

unread,

May 14, 2018, 8:26:40 PM5/14/18

to django-...@googlegroups.com

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

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

unread,

Jul 13, 2018, 11:45:04 AM7/13/18

to django-...@googlegroups.com

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

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

unread,

Jul 16, 2018, 10:15:12 AM7/16/18

to django-...@googlegroups.com

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

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

unread,

Aug 26, 2018, 6:59:17 PM8/26/18

to django-...@googlegroups.com

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

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

unread,

Mar 8, 2019, 5:43:31 AM3/8/19

to django-...@googlegroups.com

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

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

unread,

Apr 17, 2019, 5:04:42 AM4/17/19

to django-...@googlegroups.com

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

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

unread,

Jun 10, 2019, 9:56:51 AM6/10/19

to django-...@googlegroups.com

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

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

unread,

Jun 24, 2019, 2:38:49 PM6/24/19

to django-...@googlegroups.com

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

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

unread,

Aug 20, 2019, 3:41:48 PM8/20/19

to django-...@googlegroups.com

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

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

unread,

Aug 21, 2019, 2:36:01 AM8/21/19

to django-...@googlegroups.com

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

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

unread,

Feb 18, 2020, 2:28:12 PM2/18/20

to django-...@googlegroups.com

#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

unread,

Feb 19, 2020, 1:35:11 PM2/19/20

to django-...@googlegroups.com

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

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

unread,

Apr 6, 2020, 12:04:10 PM4/6/20

to django-...@googlegroups.com

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

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

unread,

May 14, 2020, 5:20:28 PM5/14/20

to django-...@googlegroups.com

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

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

unread,

Jun 11, 2020, 4:59:38 PM6/11/20

to django-...@googlegroups.com

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

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

unread,

Jun 8, 2021, 5:24:51 AM6/8/21

to django-...@googlegroups.com

#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

unread,

Jul 8, 2021, 8:23:08 AM7/8/21

to django-...@googlegroups.com

#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

unread,

Jul 20, 2021, 3:52:11 AM7/20/21

to django-...@googlegroups.com

#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

unread,

Aug 14, 2021, 12:16:11 PM8/14/21

to django-...@googlegroups.com

#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

unread,

Oct 3, 2021, 7:51:49 AM10/3/21

to django-...@googlegroups.com

#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

unread,

Nov 30, 2021, 8:07:44 AM11/30/21

to django-...@googlegroups.com

#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

unread,

Dec 13, 2021, 11:42:55 AM12/13/21

to django-...@googlegroups.com

#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

unread,

Jan 26, 2022, 2:28:08 AM1/26/22

to django-...@googlegroups.com

#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

unread,

May 27, 2022, 6:03:55 AM5/27/22

to django-...@googlegroups.com

#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

unread,

Oct 11, 2022, 3:51:10 AM10/11/22

to django-...@googlegroups.com

#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

unread,

Nov 29, 2022, 10:56:22 AM11/29/22

to django-...@googlegroups.com

#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

unread,

Nov 22, 2023, 9:32:47 AM11/22/23

to django-...@googlegroups.com

#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

unread,

Nov 28, 2023, 3:39:51 AM11/28/23

to django-...@googlegroups.com

#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

unread,

Feb 3, 2024, 11:45:16 AMFeb 3

to django-...@googlegroups.com

#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
-------------------------------------+-------------------------------------