Alternatively, with duckdb being able to read directly from an SQLite db, the standard SQL PIVOT can be used: PIVOT products ON year USING sum(income); Re

Alternatively, with duckdb being able to read directly from an SQLite db, the standard SQL PIVOT can be used: PIVOT products ON year USING sum(income); Ref: https://duckdb.org/docs/sql/statements/pivot.html https://duckdb.org/docs/sql/statements/pivot.html