Shameless plug: I created prql-query (https://github.com/PRQL/prql-query https://github.com/PRQL/prql-query) in order to scratch my own itch and use PRQL (prql-

Shameless plug: I created prql-query (https://github.com/PRQL/prql-query https://github.com/PRQL/prql-query) in order to scratch my own itch and use PRQL (prql-lang.org) with DataFusion and DuckDB for things like this. pq is overdue some maintenance but I will update it with the imminent PRQL 0.9 release. I've used pq in anger at my $dayjob and found it incredibly productive to have the full power of SQL combined with the terse and logical syntax of PRQL.