I use a little shell alias that drops me into duckdb with the file loaded into a table for interactive querying:

https://github.com/llimllib/personal_code/blob/c1a74b1b9527f...