# DuckDB v0.8.0 — Release & Upgrade Intelligence
- **Product:** DuckDB (https://duckdb.org)
- **Version:** v0.8.0
- **Released:** May 17, 2023
- **Impact Score:** 7/10
- **Breaking Changes:** Source flagged
- **Canonical Analysis:** https://changelogs.us/duckdb/updates/v0.8.0/

## Executive Summary (TL;DR)
DuckDB v0.8.0. Source highlight: This preview release of DuckDB is named "Fulvigula" after the Mottled duck (Anas fulvigula) which lives in the Gulf of Mexico, where it is apparently highly prized amongst (heartless) hunters.

## Breaking Changes & Deprecations
- There are **two SQL-level breaking changes** in this release:
- [BREAKING] Use Python-style division operator (/ is always floating point division, // is integer division) by @Mytherin in https://github.com/duckdb/duckdb/pull/7082
- [BREAKING] Switch to NULLS LAST as default null sorting order, instead of NULLS FIRST by @Mytherin in https://github.com/duckdb/duckdb/pull/7174

## New Features
- Add table functions range and generate_series for TIMESTAMPTZ
- Add Initial DuckDB Swift API
- Add support for Pivot/Unpivot statements
- [C-API] Add support for StreamQueryResult
- [Swift] add remaining non-composite types
- [Swift] Add Prepared Statements

## Improvements
- Make DISTINCT ON respect the ORDER BY clause similar to Postgres + several ordered aggregate improvements
- [Swift] Database.Configuration type + documentation enhancements
- Normalize comparisons and improve string_t operations
- Issue #5920: Ordered Aggregate Performance
- [Catalog] Improve error message on catalog-qualified catalog-entry lookup
- LIST aggregate performance improvements

## Bug Fixes
- CI: Swap cron for repository_dispatch
- Handle SQL-tagged strings correctly with dplyr::tbl, fixes #6506
- [Dev] Fix broken `test_filesystem.py` test
- Fix TPC-DS date insertion
- Fix #4016: Test amalgamation with --split param
- Fix #6602: add inet extension to build/distribute script