search

MechanicalRabbit / OHDSICohortExpressions.jl

reimplementation of OHDSI's Circe JSON->SQL compiler
Other
7 stars 1 forks source link

[FEATURE REQUEST] Add Output "SQLite" Target Syntax #5

Open TheCedarPrince opened 2 years ago

TheCedarPrince commented 2 years ago

Hi all,

Could we add SQLite target syntax for the package along side :redshift, :sqlserver and :postgresql? How hard would it be? Would it be a matter of wiring this package to use FunSQL more thoroughly? Thanks!

~ tcp :deciduous_tree:

clarkevans commented 2 years ago

There is at least one complication for SQLite: it does not have a data type for dates and times. Some people use numbers, others use a string representation. In either case, the operations on dates are not encapsulated at the database level, this complexity is relocated into the user-level code. Besides date and time handling, there may be performance differences that make certain constructs unreasonably slow, and this requires performance testing work. Regardless, this does seem worthwhile, it just won't happen without effort.