It also compiles the SQL and can run the query for you too, the whole thing is open-source, metric definitions & compilation engine. Docs probably need a little more love but linking here:
docs.lightdash.com/api-referenc...

Happy to share any examples if you need too :)

Lightdash founder here! The metrics in Lightdash's semantic layer are open-source and stored in dbt, we've released an API and a Python Client for them, you can use them wherever you want. Spreadsheets, notebooks, your pick! :)

The semantic layer in lightdash lives in dbt atm, did you anticipate something else?

Love it!!! 🌈