All evidence cases
DeepSWE v1.1repositoryTypeScript

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.

  • feature implementation
  • configuration tuning
  • bug repair
  • parser
  • compiler
  • query layer
  • library API
  • Drizzle ORM
  • SQL
  • repository patch
  • 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

ModelHarnessEffortResultPasses
claude-fable-5vertex_aimini-swe-agentpublished configurationlowAll passed4/4
claude-fable-5vertex_aimini-swe-agentpublished configurationmediumAll passed4/4
claude-fable-5vertex_aimini-swe-agentpublished configurationhighAll passed4/4
claude-fable-5vertex_aimini-swe-agentpublished configurationxhighAll passed4/4
claude-fable-5vertex_aimini-swe-agentpublished configurationmaxAll passed4/4
claude-opus-4-8anthropicmini-swe-agentpublished configurationlowAll passed4/4
claude-opus-4-8anthropicmini-swe-agentpublished configurationmediumAll passed4/4
claude-opus-4-8anthropicmini-swe-agentpublished configurationhighAll passed4/4
claude-opus-4-8anthropicmini-swe-agentpublished configurationxhighAll passed4/4
claude-opus-4-8anthropicmini-swe-agentpublished configurationmaxAll passed4/4
claude-sonnet-4-6anthropicmini-swe-agentpublished configurationhighMixed1/4
claude-sonnet-5anthropicmini-swe-agentpublished configurationlowMixed3/4
claude-sonnet-5anthropicmini-swe-agentpublished configurationmediumMixed3/4
claude-sonnet-5anthropicmini-swe-agentpublished configurationhighMixed2/4
claude-sonnet-5anthropicmini-swe-agentpublished configurationxhighAll passed4/4
claude-sonnet-5anthropicmini-swe-agentpublished configurationmaxAll passed4/4
gemini-3-1-pro-previewvertex_aimini-swe-agentpublished configurationhighNo passes0/4
gemini-3-5-flashvertex_aimini-swe-agentpublished configurationmediumMixed2/4
glm-5-2zaimini-swe-agentpublished configurationhighAll passed4/4
glm-5-2zaimini-swe-agentpublished configurationmaxAll passed4/4
gpt-5-4openaimini-swe-agentpublished configurationxhighMixed3/4
gpt-5-5openaimini-swe-agentpublished configurationlowMixed2/4
gpt-5-5openaimini-swe-agentpublished configurationmediumAll passed4/4
gpt-5-5openaimini-swe-agentpublished configurationhighAll passed4/4
gpt-5-5openaimini-swe-agentpublished configurationxhighAll passed4/4
gpt-5-6-lunaopenaimini-swe-agentpublished configurationlowNo passes0/4
gpt-5-6-lunaopenaimini-swe-agentpublished configurationmediumMixed2/4
gpt-5-6-lunaopenaimini-swe-agentpublished configurationhighAll passed4/4
gpt-5-6-lunaopenaimini-swe-agentpublished configurationxhighAll passed4/4
gpt-5-6-lunaopenaimini-swe-agentpublished configurationmaxAll passed4/4
gpt-5-6-solopenaimini-swe-agentpublished configurationlowAll passed4/4
gpt-5-6-solopenaimini-swe-agentpublished configurationmediumAll passed4/4
gpt-5-6-solopenaimini-swe-agentpublished configurationhighAll passed4/4
gpt-5-6-solopenaimini-swe-agentpublished configurationxhighAll passed4/4
gpt-5-6-solopenaimini-swe-agentpublished configurationmaxAll passed4/4
gpt-5-6-terraopenaimini-swe-agentpublished configurationlowMixed3/4
gpt-5-6-terraopenaimini-swe-agentpublished configurationmediumMixed3/4
gpt-5-6-terraopenaimini-swe-agentpublished configurationhighAll passed4/4
gpt-5-6-terraopenaimini-swe-agentpublished configurationxhighAll passed4/4
gpt-5-6-terraopenaimini-swe-agentpublished configurationmaxAll passed4/4
kimi-k2-7-codeopenroutermini-swe-agentpublished configurationdefaultMixed3/4