[fbdab103]

>Now DuckDB can actually read and write from/to SQLite

This feels like it opens up some possibilities, but I am struggling to figure out where. Are you aware of any interesting use cases this has enabled? Does all of the Duck syntax then work against the SQLite database? For example, could I now run a pivot without a bunch of hoops?

[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.