# Semantic Layer Articles

> Semantic layer deep dives: turning SQL into metrics. Comparisons of dbt, Cube.dev, and LookML. Benchmarks and patterns for scaling metrics layers.

Filter by Topic:

[All Posts (45)](/blog.md) [Engineering (31)](/blog/tag/engineering.md) [Architecture (21)](/blog/tag/architecture.md) [Performance (14)](/blog/tag/performance.md) [Product (13)](/blog/tag/product.md) [Altertable Agent (12)](/blog/tag/ai-agents.md) [Open Source (10)](/blog/tag/open-source.md) [Data Stack (9)](/blog/tag/data-stack.md) [Analytics (7)](/blog/tag/analytics.md) [AI (4)](/blog/tag/ai.md) [Culture (3)](/blog/tag/culture.md) [Generative UI (2)](/blog/tag/generative-ui.md) [Agents (2)](/blog/tag/agents.md) [Semantic Layer (2)](/blog/tag/semantic-layer.md) [Cousteau (1)](/blog/tag/cousteau.md) [MCP Apps (1)](/blog/tag/mcp-apps.md) [Agentic UI (1)](/blog/tag/agentic-ui.md) [Model Context Protocol (1)](/blog/tag/model-context-protocol.md) [Pricing (1)](/blog/tag/pricing.md)



Semantic layer deep dives: turning SQL into metrics. Comparisons of dbt, Cube.dev, and LookML. Benchmarks and patterns for scaling metrics layers.

[![A Semantic Layer in DuckDB](/assets/blog/2026-11-02-semantic-layer-in-duckdb.jpg)](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[NOVEMBER 2ND, 2026](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[Sylvain Utard](/blog/2026-11-02-semantic-layer-in-duckdb.md)

## [A Semantic Layer in DuckDB](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[Engineering, Open Source, Semantic Layer, Analytics](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[A semantic layer inside DuckDB: define metrics once in SQL, and every query, from an analyst or an AI agent, gets the joins and aggregations right.](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[READ ARTICLE](/blog/2026-11-02-semantic-layer-in-duckdb.md)

[![Semantic Layers in 2025](/assets/blog/2025-07-01-state-semantic-layers-2025.jpg)](/blog/2025-07-01-state-semantic-layers-2025.md)

[JULY 1ST, 2025](/blog/2025-07-01-state-semantic-layers-2025.md)

[Sylvain Utard](/blog/2025-07-01-state-semantic-layers-2025.md)

## [Semantic Layers in 2025](/blog/2025-07-01-state-semantic-layers-2025.md)

[Semantic Layer, Architecture, Analytics](/blog/2025-07-01-state-semantic-layers-2025.md)

[We tested four semantic layer approaches: Looker, Omni, Cube.dev, and dbt MetricFlow. Here's what we learned about each.](/blog/2025-07-01-state-semantic-layers-2025.md)

[READ ARTICLE](/blog/2025-07-01-state-semantic-layers-2025.md)

## Interested in learning more about Altertable?

[Start free](/sign-up)

[Web version](https://altertable.ai/blog/tag/semantic-layer)
