Window functions #5348

New Issue

admin · 2026-01-22T15:05:11+01:00

admin commented

2026-01-22 15:05:11 +01:00

Originally created by @ymarillet on GitHub (Dec 16, 2016).

Originally assigned to: @Ocramius on GitHub.

Hello everyone,

Does anyone know if there is any plan to make window functions available in Doctrine ?

Originally created by @ymarillet on GitHub (Dec 16, 2016). Originally assigned to: @Ocramius on GitHub. Hello everyone, Does anyone know if there is any plan to make [window functions](https://drill.apache.org/docs/sql-window-functions-introduction/) available in Doctrine ?

admin added the Improvement Can't Fix labels 2026-01-22 15:05:11 +01:00

admin closed this issue

2026-01-22 15:05:11 +01:00

admin commented

2026-01-22 15:05:11 +01:00

@Ma27 commented on GitHub (Dec 17, 2016):

doctrine supports many SQL database platforms and it seems as not each of them supports window functions, so it's unlikely that doctrine will provide native support for that.

If you'd like to do vendor-specific queries, there are two options:

use a native query and hydrate manually (http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/native-sql.html)
write your own DQL extension which makes this feature available in DQL queries (http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/cookbook/dql-user-defined-functions.html)

@Ma27 commented on GitHub (Dec 17, 2016): doctrine supports many SQL database platforms and it seems as not each of them supports window functions, so it's unlikely that doctrine will provide native support for that. If you'd like to do vendor-specific queries, there are two options: - use a native query and hydrate manually (http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/native-sql.html) - write your own DQL extension which makes this feature available in DQL queries (http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/cookbook/dql-user-defined-functions.html)

admin commented

2026-01-22 15:05:11 +01:00

@Ocramius commented on GitHub (Dec 17, 2016):

Indeed, just go with SQL when doing this sort of stuff.

Closing here as Can't Fix

@Ocramius commented on GitHub (Dec 17, 2016): Indeed, just go with SQL when doing this sort of stuff. Closing here as `Can't Fix`

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