Comment by nojito

SQL is a terrible api for data transformation.

https://duckdb.org/docs/lts/sql/statements/pivot#limitations

vs

https://docs.pola.rs/api/python/stable/reference/dataframe/a...