We built a transformation library[0] (think a simpler, more performant dbt) for duckdb and I'd really like to create a semantic layer as an extension for it at some point.

Limiting support to only duckdb would make some really useful features trivial to implement. e.g. duckdb has a `json_serialize_sql` function that would handle a lot of the tedious parts of building a semantic layer.

0 - https://github.com/definite-app/crabwalk

▲

datadrivenangel 5 days ago | parent [-]

How do you compare your library to SQLMesh?

	▲	mritchie712 5 days ago \| parent [-]
		if you're looking for something like SQLMesh, then I'd stay away from crabwalk. it's purely meant to run SQL transformations in DuckDB in a reliable way with data lineage.