@malloydata/db-duckdb

Malloy

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 relational database. Malloy currently connects to BigQuery and Postgres, and natively supports DuckDB. We've built a Visual Studio Code extension to facilitate building Malloy data models, querying and transforming data, and creating simple visualizations and dashboards.

This package

This package facilitates using the malloydata/malloy library with DuckDB - see here for additional information.

Changelog

v0.0.10

The apply operator is now ? and not :

In the transition from filters being with an array like syntax ...

sourceName :[ fieldName: value1|value2 ]

The use of : as the apply operator became a readability problem ...

sourceName { where: fieldName: value1|value2 }

As of this release, use of the : as an apply operator will generate a warning, and in a near future release it will be a compiler error. The correct syntax for apply is now the ? operator. As in

sourceName { where: fieldName ? value1|value2 }