Posts about SQL
Posts about SQL: querying data with DuckDB, transpiling SQL between dialects and generating SQL from natural language with LLMs.
9 posts
Filter by tag
Filter by tag:
Merges for DuckDB branches and snapshots
differential 1.1 brings three-way merges to DuckDB: merge branches and snapshots, fast-forward, resolve typed conflicts with a table, merge schemas, use S3.
Diffing DuckDB branches and snapshots with plain SQL
Diff DuckDB branches and snapshots with plain SQL: EXCEPT, a keyed FULL JOIN, changed columns and a reusable cell-level diff macro for differential.
Versioned DuckDB databases, locally or replicated through S3, for people and agents
differential extension for DuckDB 2.0: snapshots, branches and time travel locally, plus leader/follower replicas, failover and shared writers via S3.
Teaching coding agents the differential DuckDB extension with an Agent Skill
duckdb-differential now ships an Agent Skill, so Claude Code, Codex, Cursor and other agents can version, branch and replicate DuckDB databases correctly.
Differential storage for DuckDB
Add snapshots, time travel and writable branches to native DuckDB databases from SQL with duckdb-differential, and publish versions to S3.
Introducing polyglot - A Rust/Wasm SQL transpilation library
polyglot transpiles SQL between 33 dialects like PostgreSQL, BigQuery and Snowflake. A Rust port of sqlglot, compiled to Wasm to run in the browser and Node.js.
Chat with a Duck
Query your data in plain English: use the DuckDB-NSQL LLM via Ollama to generate DuckDB SQL from natural language prompts in the browser-based SQL Workbench.
Using DuckDB-WASM for in-browser Data Engineering
Analyze, transform and visualize local and remote data in the browser with DuckDB-WASM and SQL Workbench, including a full example data engineering pipeline.
Casual data engineering, or: A poor man's Data Lake in the cloud - Part I
Build a cost-effective, near-realtime serverless data lake on AWS with CloudFront, Kinesis Firehose, Lambda, S3, Glue and DuckDB.