[1egg0myegg0]

You could definitely run a pivot with the SQLite attach! All of the DuckDB syntax works!

[fbdab103]

Well that is just amazingly interesting. The documentation is failing to do this feature justice! Definitely going to be on my todo list to explore this bridge in the near future.