Malloy
Malloy is an experimental analytical language that provides the ability to define a semantic data model for describing and querying data relationships and transformations on SQL databases.
Malloy currently works with SQL databases BigQuery, Postgres, and querying Parquet and CSV via DuckDB.
Malloy was designed by a team of people with a lot of experience in understanding the task of extracting meaning from data. Years of constant exposure to SQL resulted in a tremendous sense of wonder at the power of SQL … and a tremendous source of frustration at how bad SQL is at representing the types of operations needed to get meaningful data out of relational databases, and how difficult it is to maintain and extend a complex set of transformations written in SQL.