Too Long; Didn't Read
Malloy is an experimental language for describing data relationships and transformations. It is both a semantic modeling language and a querying language that runs queries against a database. Malloy natively supports DuckDB, BigQuery and Postgres, and it can connect to DuckDB. There is a Visual Studio Code extension for Malloy, as well as npm modules for javascript and typescript, in addition to a Composer. The language is more evolved and open-source than Looker, which Google bought back in 2019.