Sponsor of the Day:
Jerkmate
https://duckdb.org/docs/current/sql/statements/unpivot
UNPIVOT Statement – DuckDB
The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column...
unpivotstatementduckdb
https://stackoverflow.com/questions/79790339/unpivot-explode-of-json-data-in-questdb
sql - Unpivot / explode of JSON data in QuestDB - Stack Overflow
I have data in a QuestDB database which is stored in JSON arrays, with one row per timestamp. These contain forecast data, with a forecast for the next n...
json datastack overflowsqlunpivotexplode
https://duckdb.org/docs/lts/sql/statements/unpivot
UNPIVOT Statement – DuckDB
The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column...
unpivotstatementduckdb