The author shares their shift from using Excel and Google Sheets to DuckDB for handling CSV files. They highlight the simplicity of using SQL for tasks like extracting unique user IDs and exporting data, while also noting the convenience of directly querying various data sources.

sq is a command line tool that allows you to query structured data from various sources, including SQL databases and document formats like CSV and Excel. It supports joining data across different sources and outputs results in multiple formats. You can also inspect metadata, compare tables, and perform common database operations.

The author shares their shift from using Excel and Google Sheets to DuckDB and SQL for handling CSV files, highlighting the efficiency of querying data directly. They discuss the benefits of using SQL for data manipulation and invite readers to share their own CSV handling tips.