Add typed window function builders with OVER clauses
Add typed query-builder helpers for SQL window functions, named windows, and frame specs.
drizzle-orm-window-function-builders
Normalized profile
What this task asks for
Add typed query-builder helpers for SQL window functions, named windows, and frame specs. Add typed ranking, offset, value, and aggregate window helpers whose builders expose `.over()`. Support inline and named window specifications with partitioning, ordering, and row or range frames. Emit numeric positional arguments as SQL literals rather than bound parameters. Validate positional arguments, window names, frame ordering, and frame-boundary offsets. Compile named windows before `ORDER BY` and named references as quoted `OVER` names without parentheses. Export all helpers and preserve nullable value-access typing, removing null when lag or lead has a default.
Intent
- feature implementation
- configuration tuning
- bug repair
Work surfaces
- parser
- compiler
- query layer
- library API
Technology
- Drizzle ORM
- SQL
Expected artifacts
- repository patch
What makes it difficult
- strict behavioral compatibility or exact-output validation
- native compilation and dependency integration
- specialized algorithmic or domain reasoning
- changes span multiple components or interfaces
Published evidence
Model × harness outcomes
Counts are tied to these exact configurations. Harnesses are not treated as equivalent across benchmarks.
- Models
- 13
- Configurations
- 41
- Trials
- 164
Showing 41 of 41 configurations
| Model | Harness | Effort | Result | Passes |
|---|---|---|---|---|
| claude-fable-5vertex_ai | mini-swe-agentpublished configuration | low | All passed | 4/4 |
| claude-fable-5vertex_ai | mini-swe-agentpublished configuration | medium | All passed | 4/4 |
| claude-fable-5vertex_ai | mini-swe-agentpublished configuration | high | All passed | 4/4 |
| claude-fable-5vertex_ai | mini-swe-agentpublished configuration | xhigh | All passed | 4/4 |
| claude-fable-5vertex_ai | mini-swe-agentpublished configuration | max | All passed | 4/4 |
| claude-opus-4-8anthropic | mini-swe-agentpublished configuration | low | All passed | 4/4 |
| claude-opus-4-8anthropic | mini-swe-agentpublished configuration | medium | All passed | 4/4 |
| claude-opus-4-8anthropic | mini-swe-agentpublished configuration | high | All passed | 4/4 |
| claude-opus-4-8anthropic | mini-swe-agentpublished configuration | xhigh | All passed | 4/4 |
| claude-opus-4-8anthropic | mini-swe-agentpublished configuration | max | All passed | 4/4 |
| claude-sonnet-4-6anthropic | mini-swe-agentpublished configuration | high | Mixed | 1/4 |
| claude-sonnet-5anthropic | mini-swe-agentpublished configuration | low | Mixed | 3/4 |
| claude-sonnet-5anthropic | mini-swe-agentpublished configuration | medium | Mixed | 3/4 |
| claude-sonnet-5anthropic | mini-swe-agentpublished configuration | high | Mixed | 2/4 |
| claude-sonnet-5anthropic | mini-swe-agentpublished configuration | xhigh | All passed | 4/4 |
| claude-sonnet-5anthropic | mini-swe-agentpublished configuration | max | All passed | 4/4 |
| gemini-3-1-pro-previewvertex_ai | mini-swe-agentpublished configuration | high | No passes | 0/4 |
| gemini-3-5-flashvertex_ai | mini-swe-agentpublished configuration | medium | Mixed | 2/4 |
| glm-5-2zai | mini-swe-agentpublished configuration | high | All passed | 4/4 |
| glm-5-2zai | mini-swe-agentpublished configuration | max | All passed | 4/4 |
| gpt-5-4openai | mini-swe-agentpublished configuration | xhigh | Mixed | 3/4 |
| gpt-5-5openai | mini-swe-agentpublished configuration | low | Mixed | 2/4 |
| gpt-5-5openai | mini-swe-agentpublished configuration | medium | All passed | 4/4 |
| gpt-5-5openai | mini-swe-agentpublished configuration | high | All passed | 4/4 |
| gpt-5-5openai | mini-swe-agentpublished configuration | xhigh | All passed | 4/4 |
| gpt-5-6-lunaopenai | mini-swe-agentpublished configuration | low | No passes | 0/4 |
| gpt-5-6-lunaopenai | mini-swe-agentpublished configuration | medium | Mixed | 2/4 |
| gpt-5-6-lunaopenai | mini-swe-agentpublished configuration | high | All passed | 4/4 |
| gpt-5-6-lunaopenai | mini-swe-agentpublished configuration | xhigh | All passed | 4/4 |
| gpt-5-6-lunaopenai | mini-swe-agentpublished configuration | max | All passed | 4/4 |
| gpt-5-6-solopenai | mini-swe-agentpublished configuration | low | All passed | 4/4 |
| gpt-5-6-solopenai | mini-swe-agentpublished configuration | medium | All passed | 4/4 |
| gpt-5-6-solopenai | mini-swe-agentpublished configuration | high | All passed | 4/4 |
| gpt-5-6-solopenai | mini-swe-agentpublished configuration | xhigh | All passed | 4/4 |
| gpt-5-6-solopenai | mini-swe-agentpublished configuration | max | All passed | 4/4 |
| gpt-5-6-terraopenai | mini-swe-agentpublished configuration | low | Mixed | 3/4 |
| gpt-5-6-terraopenai | mini-swe-agentpublished configuration | medium | Mixed | 3/4 |
| gpt-5-6-terraopenai | mini-swe-agentpublished configuration | high | All passed | 4/4 |
| gpt-5-6-terraopenai | mini-swe-agentpublished configuration | xhigh | All passed | 4/4 |
| gpt-5-6-terraopenai | mini-swe-agentpublished configuration | max | All passed | 4/4 |
| kimi-k2-7-codeopenrouter | mini-swe-agentpublished configuration | default | Mixed | 3/4 |