How to Load and Manage SQL Macros in MotherDuck UI for Development Workflows

I've been playing around with the motherduck notebooks, and I really thinks the ui is incredible beautiful! I am building a larger calculation engine, and I am considering having duckdb to be the base of that engine. If I should use duckdb I would need to lean heavily in to macros. Macros need to be stored in git, and I need to be able to load and run them at will. Are there any way to load .sql files into the motherduck ui? Kind of like what you would do with .read for the cli? If not, do anyone have an idea or setup for a development workflow?