DuckPlus 1.1

DuckPlus 1.1 builds on the 1.0 foundation with richer typed-expression tooling, curated parity guides for the official DuckDB demos, and hardened Sphinx-multiversion configuration so documentation for each release remains easy to navigate. The API surface continues to follow the open/closed principle: new capabilities extend managed connections, immutable relations, and typed expressions without forcing breaking changes.

Tip

All code snippets in the 1.1 guides run against the duckplus package published on PyPI. They assume Python 3.11+ and DuckDB 0.10+; if you are pinned to an older runtime, consult the ../typed_api appendix for migration notes and breaking-change callouts.

Release highlights

• DuckDB demo parity guides map the official engine showcases to DuckPlus helpers so teams can translate proof-of-concept SQL into production-ready pipelines.

• Typed function catalogue documents registered window, scalar, and aggregate helpers in a single place for easier discovery.

• Documentation infrastructure now defaults the version switcher to a stable latest alias, preventing empty dropdowns on GitHub Pages deployments.

The sections below walk through the features in increasing depth. Jump straight to the area you care about or read sequentially to build a mental model of the entire stack.

Start here

• Getting started
  • Verifying your environment
  • Opening a connection
  • Working with immutable relations
  • Typed expression DSL
  • Next steps
  • Documentation navigation
• Connection management with DuckCon
  • Lifecycle management
  • Extension loading
  • Connection configuration
  • Relationship with relations
  • Registering custom helpers
  • Testing patterns
• Immutable relation helpers
  • Constructing relations
  • Column management
  • Projection builder
  • Aggregation and window functions
  • Filtering and joins
  • Schema utilities
  • Introspection and diagnostics
  • Exporting data
• Typed expression API
  • Creating typed expressions
  • Arithmetic and comparison helpers
  • Aggregation helpers
  • Window functions
  • Conditional expressions and aliases
  • Scalar helpers
  • Select builder
  • Debugging typed expressions
• File and table readers
  • CSV reader
  • Parquet reader
  • JSON, Arrow, and database connectors
  • Composing with custom helpers
• File append helpers
  • CSV appends
  • Parquet appends
  • Table utilities
• Community extension coverage
  • Nano-ODBC
  • Excel
  • Bundled extensions
  • Roadmap
• Schema management
  • Inspecting schemas
  • Diffing relations
  • Exporters
  • Table utilities
• Practitioner demos
  • Language Server Demonstration
  • Sanitised traceability pipeline
  • DuckDB demo parity guides

If you are upgrading from DuckPlus 1.0, the Getting started chapter highlights the stable import paths while the deep-dive guides explain how each helper composes with DuckDB. The derived :doc:practitioner_demos now include a DuckDB parity checklist that mirrors the interactive demo site, and the reference/index reference documents every public class, method, and function in the 1.1 API surface so static tooling and application developers can reason about DuckPlus without inspecting the source code.