docs(window-functions): restructure into dedicated section with improved navigation by bluestreak01 · Pull Request #319 · questdb/documentation

bluestreak01 · 2026-01-11T17:34:23Z

Summary

Reorganize window functions documentation from scattered pages into a dedicated "Window Functions" category under Functions
Create clear entry point with improved navigation for both humans and LLMs
Add documentation for CUMULATIVE shorthand and other previously undocumented features
Add cross-links between WINDOW JOIN and window functions to clarify the distinction
Replace vwap() function with practical VWAP example using window functions
Document WINDOW JOIN GROUP BY limitation with workaround pattern

Changes

New Structure

Functions/
└── Window Functions/
    ├── Overview      (entry point - concepts, quick reference, patterns)
    ├── Function Reference (all 12 functions documented)
    └── OVER Syntax   (frame types, boundaries, CUMULATIVE)

Files Added

documentation/query/functions/window-functions/overview.md
documentation/query/functions/window-functions/reference.md
documentation/query/functions/window-functions/syntax.md
static/_redirects (Netlify redirects for old URLs)

Files Removed

documentation/query/functions/window.md
documentation/query/sql/over.md

Files Updated

documentation/sidebars.js - new nested category
documentation/integrations/visualization/powerbi.md - updated links
documentation/query/sql/explain.md - updated links
documentation/query/overview.md - updated links
documentation/query/sql/window-join.md - added disambiguation note + GROUP BY limitation with CTE workaround
documentation/query/functions/finance.md - replaced vwap() function with redirect to VWAP example

Improvements

Single entry point: Users searching "window functions" now land on a clear overview page
Quick reference table: Shows all functions with "Respects Frame" indicator
New documentation: CUMULATIVE shorthand, frame shorthand syntax, time-series optimization tips
Real-world VWAP example: Using OHLC data with typical price formula (high + low + close) / 3
Clear disambiguation: Notes distinguishing WINDOW JOIN (cross-table) from window functions (same table)
GROUP BY limitation: Explicit documentation that WINDOW JOIN doesn't support GROUP BY, with CTE workaround pattern
Better organization: Concepts → Reference → Syntax details
LLM-friendly: Keywords in frontmatter, structured content, cross-links, clear limitations

Redirects

Old URL	New URL
`/docs/query/functions/window/`	`/docs/query/functions/window-functions/overview/`
`/docs/query/sql/over/`	`/docs/query/functions/window-functions/syntax/`

Test plan

Verify all three new pages render correctly
Check sidebar navigation shows nested "Window Functions" category
Confirm internal links work (powerbi, explain, overview pages)
Test redirects work on Netlify deploy preview
Verify WINDOW JOIN page shows disambiguation note and GROUP BY limitation
Confirm finance.md VWAP section links to window functions example

🤖 Generated with Claude Code

github-actions · 2026-01-11T17:36:11Z

🚀 Build success!

Latest successful preview: https://preview-319--questdb-documentation.netlify.app/docs/

Commit SHA: e834eda

📦 Build generates a preview & updates link on each commit.

…ved navigation Reorganize window functions documentation from scattered pages into a dedicated "Window Functions" category under Functions for better discoverability. Changes: - Create new window-functions/ directory with three focused pages: - overview.md: Entry point with concepts, quick reference table, common patterns - reference.md: Complete function reference (avg, sum, count, rank, lag, lead, etc.) - syntax.md: OVER clause syntax, frame types, CUMULATIVE shorthand - Remove old scattered pages (window.md, over.md) - Update sidebar navigation with new nested category - Update internal links in powerbi.md, explain.md, overview.md - Add Netlify redirects for old URLs Improvements: - Single clear entry point for users searching "window functions" - Quick reference table showing all functions with "Respects Frame" indicator - Document CUMULATIVE shorthand and frame shorthand syntax - Add time-series optimization tips - Add VWAP example - Better organized content: concepts -> reference -> syntax details Co-Authored-By: Claude Opus 4.5 <[email protected]>

documentation/query/functions/window-functions/syntax.md

documentation/query/functions/window-functions/overview.md

- Add frame_start and frame_end syntax definitions to syntax.md - Add syntax synopsis section to overview.md for newcomers - Fix incorrect RANGE frame limitation description (issue #5177) Co-Authored-By: Claude Opus 4.5 <[email protected]>

Adds visual animation to help newcomers understand how window functions slide through rows. Co-Authored-By: Claude Opus 4.5 <[email protected]>

- Add syntax to main syntax block - Add dedicated section with examples and use cases - Mention supported functions: first_value, last_value, lag, lead - Add brief mention in overview syntax section Co-Authored-By: Claude Opus 4.5 <[email protected]>

- Explain that calculations reset for each partition - Add "When to use it" with capital markets examples - Add side-by-side SQL comparison (with/without partition) - Add table showing difference in results per symbol Co-Authored-By: Claude Opus 4.5 <[email protected]>

Replace car race analogy with concrete aggregate vs window function comparison showing: - Source data table - Aggregate query and result (1 row) - Window function query and result (all rows) - Capital markets terminology (BTC-USD trades) Co-Authored-By: Claude Opus 4.5 <[email protected]>

Window function arithmetic (e.g., division between two window functions) requires version 9.3.1+. Earlier versions need CTEs or subqueries as workarounds. Co-Authored-By: Claude Opus 4.5 <[email protected]>

The SQL snippets already indicate they're demo-able via the UI. Co-Authored-By: Claude Opus 4.5 <[email protected]>

- Add SVG animation to static assets - Reference local file instead of GitHub user-attachments URL Co-Authored-By: Claude Opus 4.5 <[email protected]>

Update links in 17 cookbook files to point to the new window functions documentation location under /docs/query/functions/window-functions/. Co-Authored-By: Claude Opus 4.5 <[email protected]>

bluestreak01 mentioned this pull request Jan 11, 2026

feat(sql): implement arithmetic with window functions questdb/questdb#6626

Merged

4 tasks

bluestreak01 force-pushed the vi_window branch 7 times, most recently from 2bd98f4 to 0e51846 Compare January 11, 2026 21:15

bluestreak01 force-pushed the vi_window branch from 0e51846 to 2cf42a2 Compare January 11, 2026 21:16

RaphDal reviewed Jan 12, 2026

View reviewed changes

documentation/query/functions/window-functions/syntax.md Show resolved Hide resolved

RaphDal reviewed Jan 12, 2026

View reviewed changes

documentation/query/functions/window-functions/overview.md Show resolved Hide resolved

RaphDal reviewed Jan 12, 2026

View reviewed changes

documentation/query/functions/window-functions/overview.md Show resolved Hide resolved

jerrinot reviewed Jan 12, 2026

View reviewed changes

documentation/query/functions/window-functions/overview.md Outdated Show resolved Hide resolved

jerrinot reviewed Jan 12, 2026

View reviewed changes

documentation/query/functions/window-functions/overview.md Show resolved Hide resolved

jerrinot reviewed Jan 12, 2026

View reviewed changes

documentation/query/functions/window-functions/overview.md Outdated Show resolved Hide resolved

jerrinot reviewed Jan 12, 2026

View reviewed changes

documentation/query/functions/window-functions/overview.md Outdated Show resolved Hide resolved

bluestreak01 and others added 9 commits January 12, 2026 14:14

docs(window-functions): add animation to overview

f680e96

Adds visual animation to help newcomers understand how window functions slide through rows. Co-Authored-By: Claude Opus 4.5 <[email protected]>

docs(window-functions): add version note for arithmetic support

1f3632c

Window function arithmetic (e.g., division between two window functions) requires version 9.3.1+. Earlier versions need CTEs or subqueries as workarounds. Co-Authored-By: Claude Opus 4.5 <[email protected]>

docs(window-functions): remove redundant demo tip boxes

8693bca

The SQL snippets already indicate they're demo-able via the UI. Co-Authored-By: Claude Opus 4.5 <[email protected]>

docs(window-functions): update animation with highlighted query syntax

a41c26b

- Add SVG animation to static assets - Reference local file instead of GitHub user-attachments URL Co-Authored-By: Claude Opus 4.5 <[email protected]>

Merge branch 'main' into vi_window

0d21669

jerrinot approved these changes Jan 13, 2026

View reviewed changes

bluestreak01 and others added 2 commits January 13, 2026 19:25

Merge branch 'main' into vi_window

032c1ea

fix broken links to window functions docs in cookbook

e834eda

Update links in 17 cookbook files to point to the new window functions documentation location under /docs/query/functions/window-functions/. Co-Authored-By: Claude Opus 4.5 <[email protected]>

bluestreak01 merged commit 99276b7 into main Jan 13, 2026
2 checks passed

bluestreak01 deleted the vi_window branch January 13, 2026 20:16

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

docs(window-functions): restructure into dedicated section with improved navigation#319

docs(window-functions): restructure into dedicated section with improved navigation#319
bluestreak01 merged 12 commits intomainfrom
vi_window

bluestreak01 commented Jan 11, 2026 •

edited

Loading

Uh oh!

github-actions bot commented Jan 11, 2026 •

edited

Loading

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants

Conversation

bluestreak01 commented Jan 11, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Summary

Changes

New Structure

Files Added

Files Removed

Files Updated

Improvements

Redirects

Test plan

Uh oh!

github-actions bot commented Jan 11, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants

bluestreak01 commented Jan 11, 2026 •

edited

Loading

github-actions bot commented Jan 11, 2026 •

edited

Loading