I built a VSCode extension so you can explore and query a DuckDb.
It’s built on top of the very excellent SQLTools ecosystem.
Find it’s much easier than the CLI to work out what your columns and tables are called.
It also has autocomplete for basic keywords.
See it in action here: https://x.com/archieemwood/status/16893165620359331856