DuckDB

Data Manipulation

An in-process SQL OLAP database management system, great for analytics.

Installation
pip install duckdb
Documentation
Official Docs

Chapters Using DuckDB

Chapter 43: Advanced SQL: Window Functions & CTEs (Databases & SQL for Data Science)