It is conceivable that this could become a duckdb extension, such that it can be used from within the duckdb CLI? That would be pretty slick.

That is conceivable, not a top priority as we want to focus on this being a great experience for every backend, but certainly something we are thinking of

With the new PEG parser this is just a Claude session away in DuckDB.