[FEATURE REQUEST] Add Output "SQLite" Target Syntax

[TheCedarPrince]

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 🌳

[clarkevans]

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.