### Author:  [@stschiff](https://talk.observablehq.com/u/stschiff)
#### Post date: [March 1, 2025, 1:01pm UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/5 "2025-03-01T13:01:59Z")
OK, so then it is indeed 1.24, so I don’t get why the PIVOT command then doesn’t work… I tried this in Chrome, so I don’t see a link to the Safari error that you quote. Thanks.
---
### Author:  [@mootari](https://talk.observablehq.com/u/mootari)
#### Post date: [March 1, 2025, 6:22pm UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/6 "2025-03-01T18:22:27Z")
Because duckdb-wasm versions don’t follow DuckDB. Version 1.24.0 bundles DuckDB version 0.7.1:
> **[duckdb-wasm/submodules at v1.24.0 · duckdb/duckdb-wasm](https://github.com/duckdb/duckdb-wasm/tree/v1.24.0/submodules)**
>
> WebAssembly version of DuckDB. Contribute to duckdb/duckdb-wasm development by creating an account on GitHub.
You can follow this issue for updates:
>
>
> \*\*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)
---
### Author:  [@stschiff](https://talk.observablehq.com/u/stschiff)
#### Post date: [March 3, 2025, 10:31am UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/7 "2025-03-03T10:31:52Z")
Aahh, OK, got it. Sorry, and thanks for pointing me to the GitHub issue on the matter. Very helpful!
---
### Author:  [@mootari](https://talk.observablehq.com/u/mootari)
#### Post date: [March 3, 2025, 3:32pm UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/8 "2025-03-03T15:32:28Z")
@stschiff Would you mind giving this a try?
> **[DuckDBClient with DuckDB 1.1.1](https://observablehq.com/@mootari/duckdbclient)**
>
> Creates a patched \`DuckDBClient\` with duckdb-wasm 1.29.0 (duckdb 1.1.1). Usage: Example Implementation
Edit: I had messed up the original description - it’s duckdb-wasm 1.29.0 and duckdb 1.1.1.
---
### Author:  [@stschiff](https://talk.observablehq.com/u/stschiff)
#### Post date: [March 5, 2025, 4:24pm UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/9 "2025-03-05T16:24:01Z")
Great. Your patch worked for me! I tested on Chrome and Safari, and it seemed to work on both browsers!
---
### Author:  [@mootari](https://talk.observablehq.com/u/mootari)
#### Post date: [March 6, 2025, 10:05am UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/10 "2025-03-06T10:05:33Z")
Thanks for checking! I think the problem in Safari only shows itself with file attachments that get compressed at rest (which isn’t the case for every MIME type and requires a certain effective reduction in size).
---
### Author:  [@stschiff](https://talk.observablehq.com/u/stschiff)
#### Post date: [October 7, 2025, 9:08pm UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/11 "2025-10-07T21:08:16Z")
Just a quick update here: I noticed that with your latest DuckCBClient, when I try to run: `db = DuckDBClient.of({query_data: FileAttachment(“my_file.tsv”)})` I get en error `db = Error: invalid source: [object Object]`. The same code works with the native (and old-version) DuckDBClient.
And this happens on both Chrome and Safari, so not sure whether it’s related to the issue you mentioned. I can try to make a minimal example, but I’m traveling the next days, so might take me a bit.
---
### Author:  [@mootari](https://talk.observablehq.com/u/mootari)
#### Post date: [October 8, 2025, 9:34am UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/12 "2025-10-08T09:34:15Z")
@stschiff There was an `instanceof` check against `FileAttachment` that I’ve now replaced with a test of the constructor name. Can you give it another try?
---
### Author:  [@stschiff](https://talk.observablehq.com/u/stschiff)
#### Post date: [October 21, 2025, 8:02am UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/13 "2025-10-21T08:02:09Z")
Hmm, with json data it doesn’t seem to work. See here: [https://observablehq.com/d/e524c4c8116e3af9](https://observablehq.com/d/e524c4c8116e3af9)
---
### Author:  [@mootari](https://talk.observablehq.com/u/mootari)
#### Post date: [October 21, 2025, 2:27pm UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/14 "2025-10-21T14:27:09Z")
@stschiff I can’t access that.
---
### Author:  [@stschiff](https://talk.observablehq.com/u/stschiff)
#### Post date: [October 21, 2025, 3:36pm UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/15 "2025-10-21T15:36:30Z")
Sorry, now you should be able to.
---
### Author:  [@mootari](https://talk.observablehq.com/u/mootari)
#### Post date: [October 25, 2025, 9:19am UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/16 "2025-10-25T09:19:41Z")
You need to update your import. Imports from other workspaces are locked by default.
---
### Author:  [@stschiff](https://talk.observablehq.com/u/stschiff)
#### Post date: [October 27, 2025, 7:04am UTC](https://talk.observablehq.com/t/duckdb-pivot-on-sql-statement/10282/17 "2025-10-27T07:04:58Z")
Aaaah, thank you. OK. Sorry, this was the first time I came across the import-locking feature. Very cool. And thanks for the continuous help! It works now.