# Row by Row, the DB Quacks blog

Interactive SQL and DuckDB tutorials, dev notes, and releases. Full text of every post: https://dbquacks.com/llms-full.txt

## [Shaping the Roster: SQL's Core Clauses, the DuckDB Way](https://dbquacks.com/blog/shaping-the-roster.md)

2026-06-13 · tutorial

Who scored highest? Which team came out ahead? How many games did each duck play? We've got a database full of ducks — let's learn the SQL to ask.

## [Looking Through the WINDOW: OVER, Frames, and Ranking in DuckDB](https://dbquacks.com/blog/looking-through-the-window.md)

2026-06-13 · tutorial

How does each duck stack up against its team, its rivals, and its own past? Let's learn window functions to answer them — without collapsing a single row.

## [Welcome to Row by Row](https://dbquacks.com/blog/welcome-to-row-by-row.md)

2026-05-28 · release

Meet the new interactive SQL blog that turns every code block into a runnable DuckDB query.

## [Two Ducks, One Database: A Hands-On Tour of Quack](https://dbquacks.com/blog/quack-remote-protocol-hands-on.md)

2026-05-28 · tutorial

One DuckDB serves, another attaches over HTTP, and a single statement plans across both. The end of one-writer-at-a-time.