#28333: Filter and subquery for window expressions -------------------------------------+------------------------------------- Reporter: Mads Jensen | Owner: Simon | Charette Type: New feature | Status: assigned Component: Database layer | Version: dev (models, ORM) | Severity: Normal | Resolution: Keywords: window orm filter | Triage Stage: Accepted subquery GSoC | Has patch: 1 | Needs documentation: 0 Needs tests: 1 | Patch needs improvement: 1 Easy pickings: 0 | UI/UX: 0 -------------------------------------+-------------------------------------
Comment (by Mariusz Felisiak <felisiak.mariusz@…>): In [changeset:"f387d024fc75569d2a4a338bfda76cc2f328f627" f387d024]: {{{ #!CommitTicketReference repository="" revision="f387d024fc75569d2a4a338bfda76cc2f328f627" Refs #28333 -- Added partial support for filtering against window functions. Adds support for joint predicates against window annotations through subquery wrapping while maintaining errors for disjointed filter attempts. The "qualify" wording was used to refer to predicates against window annotations as it's the name of a specialized Snowflake extension to SQL that is to window functions what HAVING is to aggregates. While not complete the implementation should cover most of the common use cases for filtering against window functions without requiring the complex subquery pushdown and predicate re-aliasing machinery to deal with disjointed predicates against columns, aggregates, and window functions. A complete disjointed filtering implementation should likely be deferred until proper QUALIFY support lands or the ORM gains a proper subquery pushdown interface. }}} -- Ticket URL: <https://code.djangoproject.com/ticket/28333#comment:30> Django <https://code.djangoproject.com/> The Web framework for perfectionists with deadlines. -- You received this message because you are subscribed to the Google Groups "Django updates" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-updates+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/01070182a07ba732-f1225fee-f183-4820-bee3-84471077d7cd-000000%40eu-central-1.amazonses.com.