DuckDB is an embedded database, similar to SQLite, but designed for OLAP-style analytics. It is crazy fast and allows you to read and write data stored in CSV, JSON, and Parquet files directly, ...

Note: The database uses UUID as a data type for IDs, the tables contain integers as IDs to keep illustration simple.