Feature Request: PARTITION BY #7364

New Issue

admin · 2026-01-22T15:50:43+01:00

admin commented

2026-01-22 15:50:43 +01:00

Originally created by @ghost on GitHub (May 7, 2024).

Feature Request

Q	A
New Feature	yes
RFC	no
BC Break	no

Summary

Being able to use "PARTITION BY" in $this->createQueryBuilder()->select().

it would help to take away the need to build a workaround for a query that is using this:

SELECT 
    customer_id,
    COUNT(*) OVER (PARTITION BY customer_id) AS order_count_per_customer
FROM 
    Orders;

Originally created by @ghost on GitHub (May 7, 2024). ### Feature Request  | Q | A |------------ | ------ | New Feature | yes | RFC | no | BC Break | no #### Summary  Being able to use "PARTITION BY" in $this->createQueryBuilder()->select(). it would help to take away the need to build a workaround for a query that is using this: ```SQL SELECT customer_id, COUNT(*) OVER (PARTITION BY customer_id) AS order_count_per_customer FROM Orders; ```

admin commented

2026-01-22 15:50:43 +01:00

@garak commented on GitHub (May 7, 2024):

I support that, but I think it should be more general and include broader support for window functions.
I see that this was already proposed and rejected in #6175 but maybe it should be reconsidered now.

By the way, all the DBMSs supported by doctrine/dbal have now support for window functions, which are not "vendor-specific" (like mentioned in the issue above)

@garak commented on GitHub (May 7, 2024): I support that, but I think it should be more general and include broader support for window functions. I see that this was already proposed and rejected in #6175 but maybe it should be reconsidered now. By the way, all the DBMSs supported by doctrine/dbal have now support for window functions, which are not "vendor-specific" (like mentioned in the issue above)

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#7364