Open TheCedarPrince opened 6 months ago
DuckDB should work with FunSQL if you use SQLite dialect, but there's no support for it in OHDSICohortExpressions. If you want DuckDB support in OHDSICohortExpressions, please open an issue there.
DuckDB should work with FunSQL if you use SQLite dialect
probably PostgreSQL dialect though? they use PostgreSQL parser (with some extensions now)
DuckDB should work with FunSQL if you use SQLite dialect
probably PostgreSQL dialect though? they use PostgreSQL parser (with some extensions now)
Good point. When I tried DuckDB with FunSQL, I used SQLite dialect, but it wasn't a comprehensive testing, so it may fail in some corner cases of SQL grammar. I suppose, DuckDB deserves its own dialect.
Ah gotcha -- I'll open an issue over in OHDSICohortExpressions.jl as well. Thanks @xitology ! :smile:
Hi @xitology and @clarkevans !
I was wondering, would it be possible to support DuckDB syntax here? I had read the syntax was very similar to PostgreSQL, so I ran OHDSICohortExpressions with the model flavor set to PostgreSQL but I got an error that looked like this
I could give my whole SQL expression for what I am trying but am curious if there'd ever be interest to support DuckDB. Thanks!