Popular：
Virtualization DNS security formal verification reachability analysis compiler errors macro conflict web extension development framework Bitmap Graphics API inconsistencies All Tags

Building the Simplest Semantic Layer with YAML and Python

2025-08-20
Building the Simplest Semantic Layer with YAML and Python

This article demonstrates building a minimal semantic layer using a YAML file and a Python script, querying 20 million NYC taxi records to illustrate its value. It clarifies when a semantic layer is truly beneficial and when it's overkill. The piece contrasts semantic layers with traditional databases, highlighting advantages in data governance, caching, secure access control, and LLM integration.

Read more
(motherduck.com)
Development semantic layer

Instant SQL: Say Goodbye to Tedious Query Building

2025-04-24
Instant SQL: Say Goodbye to Tedious Query Building

MotherDuck introduces Instant SQL, a revolutionary approach to writing SQL. This new feature provides real-time result set updates as you type, dramatically speeding up query building and debugging. No more waiting for queries to run; Instant SQL offers zero-latency feedback. It tackles the age-old problem of slow and tedious SQL writing by enabling real-time result previews, CTE inspection and editing, and effortless breakdown of complex column expressions. It supports all data sources queryable by DuckDB and integrates seamlessly with AI-powered suggestions. This breakthrough leverages DuckDB's speed, AST parsing, precise cursor mapping, and intelligent caching.

Read more
(motherduck.com)
Development