I got excited about duckdb recently too. Used it yesterday for a new project at work and immediately ran into a not implemented exception for my (awful) column

I got excited about duckdb recently too. Used it yesterday for a new project at work and immediately ran into a not implemented exception for my (awful) column naming structure and discovered there is no pivot function. Otherwise, it's great, but obviously still a wip. For those wondering, I have a helper function for soql queries for salesforce that follows the structure object.field Referring to a tablealias.[column.name] or quotes instead of brackets was a no go.