SQL is a terrible api for data transformation. https://duckdb.org/docs/lts/sql/statements/pivot#limitations https://duckdb.org/docs/lts/sql/statements/pivot#li

SQL is a terrible api for data transformation. https://duckdb.org/docs/lts/sql/statements/pivot#limitations https://duckdb.org/docs/lts/sql/statements/pivot#limitations vs https://docs.pola.rs/api/python/stable/reference/dataframe/api/polars.DataFrame.pivot.html https://docs.pola.rs/api/python/stable/reference/dataframe/a...