16

To clarify my question I would like to know if it is possible to idiomatically use the Django ORM whilst accessing CTE features. I imagine I could use CTE by writing raw SQL statements but the ability to use the ORM 'syntactic sugar' to bypass hand coding SQL statements was one of the original appeals of Django.

funnydman
  • 9,083
  • 4
  • 40
  • 55
Hoa
  • 19,858
  • 28
  • 78
  • 107

2 Answers2

12

Django doesn't support CTEs directly as these are not common to all databases (MySQL pre-8.0 didn't support it). There are packages that extend the capability of Django's ORM to support CTEs. One of these is django-cte. Note that it only supports PostgreSQL.

CadentOrange
  • 3,263
  • 1
  • 34
  • 52
  • 4
    MySQL does now support CTEs, as does SQLite, Oracle, and PostgreSQL. All of which Django supports. – Bobort Nov 29 '17 at 19:59
  • 1
    If someone is wondering: _django-cte-forest_ is a fork of _django-cte-trees_. – jnns Sep 16 '22 at 07:45
2

It seems that nowadays django-cte is a better option. It works with the existing support for CTEs in underlying database engines.

smido
  • 771
  • 6
  • 14