PSDuckDB

0.1.5

examples/07-pivot.ps1

                                Import-Module $psscriptroot\..\PSDuckDB.psd1 -Force

$dataset = "$psscriptroot/../data/otherData/cities.csv"

$stmt = @"

CREATE TABLE Cities AS SELECT * FROM '$dataset';

PIVOT Cities

ON Year

USING sum(Population);

"@

psduckdb -command $stmt | Format-Table