[ANN] SQLCollections.jl – use Julia data manipulation functions for databases

Currently, only single-table operations are directly supported in SQLCollections.jl. However, I noticed that you can just pass any FunSQL expression as the input – not just table names!
It enables operating on joins:

using SQLCollections
using FunSQL: From, Join, Get

X = SQLCollection(conn, From(:tbl1) |> Join(:tbl2 => From(:tbl2), Get.id .== Get.tbl2.id))

After that, you can work with X same as with any other SQLCollection. Julia and FunSQL composability make it work automatically.

But this isn’t the same syntax as one uses with plain Julia datasets, of course.
So I still plan to add FlexiJoins.jl joins support to SQLCollections :slight_smile:

1 Like