duckdb

DuckDB — the in-process, columnar, vectorized OLAP SQL engine shipped as a single zero-dependency binary ("SQLite for analytics"). Use when querying Parquet/CSV/JSON files directly with SQL and no load step, doing in-process analytical/OLAP queries and aggregations, using the duckdb CLI shell (interactive REPL or -c/-json one-shots for scripts and agents), writing "friendly SQL" (FROM-first, SELECT * EXCLUDE, GROUP BY ALL, SUMMARIZE, PIVOT), converting CSV↔Parquet↔JSON with COPY, reading remote data over HTTP/S3 via the httpfs extension, or ATTACH-ing a live Postgres/MySQL/SQLite database. Triggers on mentions of duckdb, the duckdb command, .duckdb files, replacement scans, read_parquet/read_csv, httpfs/CREATE SECRET, or "embedded analytics database". This is the DuckDB CLI and SQL dialect, NOT a generic SQL tutorial and NOT the DuckDB client libraries (Python/Node/Java — defer those to duckdb.org).