In a pet project I used DuckDB, which could easily be replaced by MotherDuck when going full cloud. Very impressed by DuckDB it is almost comically performant in a good way. I combine it with Dagster, dbt and dlt. The project is available here: https://github.com/edwinweber/dbt_duckdb_demo_public (edited)