DuckDB via Python is my go-to for that first use case. It’s easier than ever to use Python and SQL together with Marimo notebooks.
``` uv run --with marimo marimo run --sandbox ```
and you’re ready to go.