[dizk12]

I think the Tidier.jl has made data in julia quite nice. TidierData leverages Dataframes.jl on the backend but with tidyverse syntax, and TidierDB.jl recreates python's ibis and Rs dbplyr. TidierDB (DuckDB is the main backend, but supports 11 other DB backends) also enables grouped window functions quite smoothly as well as joins and non equijoins.

https://github.com/TidierOrg/TidierDB.jl https://github.com/TidierOrg/TidierData.jl

of note i am biased as a tidier contributor and author of tidierdb.jl but hopefully you might be willing to give it a try.