A very convenient and light-weight database used as a backend for many systems (e.g forge in Emacs; org-roam in Emacs).

Thanks to this tweet I learnt you can run SQLIte3 queries directly against CSV files.

snippet.bash

sqlite3 :memory: -cmd '.mode csv' -cmd '.import taxi.csv taxi' -cmd '.mode column' 'SELECT passenged_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger count'

Practical SQL for Data Analysis | Haki Benita