DuckDB 'PIVOT ON' SQL statement

mootari · March 1, 2025, 6:22pm

Because duckdb-wasm versions don’t follow DuckDB. Version 1.24.0 bundles DuckDB version 0.7.1:

You can follow this issue for updates:

github.com/observablehq/feedback

Update duckdb-wasm to latest

opened 01:37AM - 09 Aug 23 UTC

jzavala-gonzalez

Bug Data Access

**Is your feature request related to a problem? Please describe.** I'm writing …a notebook that uses the native Observable DuckDB client. One query attempts using DuckDB's UNPIVOT statement introduced in DuckDB 0.8.0 (released around mid-May 2023, see [announcement](https://duckdb.org/2023/05/17/announcing-duckdb-080.html) and [docs](https://duckdb.org/docs/sql/statements/unpivot.html#unpivot-into-multiple-value-columns)). The query fails with a syntax error (see screenshot) which I'm guessing is due to an outdated duckdb-wasm version in Observable. Checking the stdlib [dependencies file](https://github.com/observablehq/stdlib/blob/main/src/dependencies.js) shows Observable is using version 1.24.0 of duckdb-wasm, which was published in March [according to npm](https://www.npmjs.com/package/@duckdb/duckdb-wasm?activeTab=versions). That months-long difference between 1.24.0 and 1.27.0 could explain why UNPIVOT isn't working within yet Observable. **Describe the solution you'd like** Update to the latest version of duckdb-wasm, which at time of writing is 1.27.0 and was published mid-June. **Describe alternatives you've considered** If updating isn't possible, one could update the intro notebook ["Hello, DuckDB"](https://observablehq.com/@observablehq/duckdb) to mention what version of duckdb Observable is currently running so users can look at the correct documentation. **Additional context** ![unpivot syntax error](https://github.com/observablehq/feedback/assets/7855609/aaa840e4-e154-4d7f-9f2c-d8ff9f5a2c1d) ![stdlib dependencies](https://github.com/observablehq/feedback/assets/7855609/af204603-4379-452f-ad54-8d230b859aa8) ![npm duckdb-wasm versions](https://github.com/observablehq/feedback/assets/7855609/a830a811-450c-4b53-8a1d-95dfe3031080)

Topic		Replies	Views
Unpivot Operations with DuckDBClient Help	6	111	September 4, 2024
DuckDB isn't working Help	2	263	December 13, 2022
DuckDB is not returning rows for Parquet files Help	15	1561	July 31, 2024
how to use duckdb and DuckDBClient Help	9	546	July 26, 2024
Data table cell arrow data support Help	13	215	September 12, 2024

DuckDB 'PIVOT ON' SQL statement

Related topics