I used to use Hex but Marimo (OSS local first) honestly renders it completely obsolete for me

It similarly offers the combo of SQL and dataframes, built in dataviz and UI widgets, great LLM integration and essentially everything else one would want from either a notebook or a BI tool