See also [ANN] SQLCollections.jl – use Julia data manipulation functions for databases for a somewhat complementary direction. SQLCollections allows using regular Julia operations on SQL databases, nice for big/out of memory/remote data.
Should be fully composable!
Some features are possible but not implemented yet (it’s just ~200 LOC) – such as joins or using arbitrary Julia UDFs.
It would be nice to understand and list specific limitations of such an approach of using SQL databases compared to querying pure-Julia structures, as @xiaodai plans. Some of them can realistically be possible to overcome indeed!