MechanicalRabbit / FunSQL.jl

Julia library for compositional construction of SQL queries
https://mechanicalrabbit.github.io/FunSQL.jl
Other
144 stars 5 forks source link

Allow FunSQL "views" in SQLCatalog #55

Open xitology opened 5 months ago

xitology commented 5 months ago

The SQLCatalog mapping stores available SQL tables indexed by name. It is used for resolving query nodes From(name::Symbol).

We should extend SQLCatalog to allow entries that are arbitrary FunSQL queries. Such entries can be interpreted as CTEs. This will be useful, in particular, for composable ETL pipelines.