stdlib icon indicating copy to clipboard operation
stdlib copied to clipboard

update DuckDbClient with DuckDb v 0.8

Open ericemc3 opened this issue 1 year ago • 2 comments

Last DuckDb releases (as of 0.8.0) include PIVOT and UNPIVOT, both very useful SQL features for reshaping data.

ericemc3 avatar Jul 13 '23 08:07 ericemc3

Documentation:

  • https://duckdb.org/docs/sql/statements/pivot
  • https://duckdb.org/docs/sql/statements/unpivot

Fil avatar Jul 16 '23 15:07 Fil

DuckDB 0.8.0 was included in https://github.com/duckdb/duckdb-wasm/releases/tag/v1.26.0

We are currently using 1.24 (https://github.com/observablehq/stdlib/commit/89f27007453ea1919493dca3fb94b7a5bde03222), see https://github.com/observablehq/stdlib/blob/main/src/dependencies.js

Fil avatar Jul 18 '23 06:07 Fil