OK, so I'm not sure this is even truly a bug, more just an annoying corner case. The problem is: when pivoting on multiple columns, the new column names are made from joining the pivot values with '_' ...
I've run into a couple of parser errors using DuckDB's SQL Standard PIVOT syntax (i.e. the non-simplified version). The example statements below are taken from DuckDB's own examples for the standard ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results