Core Concepts

Learn the fundamentals of working with Drizzle DuckDB.

Topics

• Database Connection: connect to in-memory, local file, or MotherDuck
• Schema Definition: define tables, columns, and relations
• Queries: SELECT, INSERT, UPDATE, DELETE, CTEs, and aggregations
• Transactions: atomic operations and rollback handling
• Array Operations: working with LIST and ARRAY columns

---

Table of contents

• Database Connection
• Schema Definition
• Queries
• Transactions
• Array Operations