[jasonjmcghee]

Yours looks much better for your use case, but fwiw you can do it in a single command with duckdb too (but not interactive etc.):

    duckdb -c "from 'foo.parquet'"

but maybe still useful for other formats or multi-file or remote situations

[llimllib]

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...