[Feature]: Motherduck Cloud Prod / Local DuckDB support

[archiewood]

Description

I want to have a local ddb for local dev, and use MD, when pushing to prod

What problem would this solve?

Great DX for working with duckdb

How should it work?

I think we could add a checkbox setting to motherduck settings that uses a different local file when you are in dev vs motherduck in prod