Captured real DuckDB-Wasm result with source CSV and SQL

Select the code and use your copy shortcut. Changes in this preview are temporary.

<!doctype html><html lang="en"><meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1"><title>Stock CSV: captured DuckDB-Wasm reading</title><style>*{box-sizing:border-box}body{font:16px/1.6 system-ui;padding:20px;margin:0;max-width:900px;color:#25364b}h1{font-size:26px;line-height:1.2}table{width:100%;border-collapse:collapse}th,td{text-align:left;padding:9px;border-bottom:1px solid #ccd5de}pre{white-space:pre-wrap;overflow-wrap:anywhere;padding:12px;background:#f1f4f7}</style><h1>Stock CSV: captured query reading</h1><p>Fictional extract. Static reading copy of an actual DuckDB-Wasm 1.29.0 browser execution; this page does not run a database or submit work.</p><table><caption>Registered stock.csv, grouped by location</caption><thead><tr><th>Location</th><th>Source rows</th><th>Units</th></tr></thead><tbody><tr><td>North</td><td>2</td><td>11</td></tr><tr><td>South</td><td>1</td><td>4</td></tr></tbody></table><h2>Original CSV</h2><pre>location,units
North,6
South,4
North,5</pre><h2>Executed SQL</h2><pre>SELECT location, COUNT(*)::INTEGER AS source_rows,
SUM(units)::INTEGER AS units
FROM stock GROUP BY location ORDER BY location;</pre><p>Independent reconciliation: North6+5=11; South4; three source rows and15units overall. The original engine source and native execution records accompany the article.</p></html>