[FEATURE REQUEST] Support for DuckDB?

[TheCedarPrince]

Following on from a discussion from here: MechanicalRabbit/FunSQL.jl#48 (comment)

@xitology suggested I open a request here for supporting DuckDB in OHDSICohortExpressions.jl. I had tried running a Model against a DuckDB database with the model syntax changed to :postgresql and :sqlite but the computation failed.

What could I do next here @xitology and @clarkevans to help bring this feature to full? Is there anything I could do?

Thanks!

~ tcp 🌳

[clarkevans]

@TheCedarPrince What might move this ticket forward is if the 100 person MIMIC sample was converted to CSVS, packaged as a Julia data package with DuckDB loader. We might then start to use it as the primary regression test.

[TheCedarPrince]

Thanks to MechanicalRabbit/FunSQL.jl#69, this looks like it can be possible. I can provision this through https://github.com/JuliaHealth/HealthSampleData.jl to provide that sample and start a PR for this.