duckrun

!pip install duckrun --upgrade
notebookutils.session.restartPython()

import duckrun

# read-only by default — explore safely, no accidental writes
conn = duckrun.connect("./my_lakehouse/Tables")   # or abfss://…onelake… for OneLake
conn.sql("select status, count(*) from orders group by status").show()
reader = conn.table("orders").toArrow()   # streaming pyarrow.RecordBatchReader

duckrun is just glue — the real work is done by DuckDB, delta-rs, dbt-duckdb and Apache Arrow.