MotherDuck distinguishes semantic layers, context layers, and ontologies. Shared metric definitions, business context, and explicit relationships each contribute something different; choosing an architecture starts with identifying which of those problems an AI application actually needs to solve.
From the linked article:
The context layer primarily supports the accuracy of SQL queries, continuous updates to the business context, and governance.
Source: @motherduck. This note summarizes the linked material; images belong to their respective creators.