this PR switches out sql-template-strings for sql-template-tags to allow for easier SQL query nesting and reusing of abstracted sub-queries.
To use the ESM-only package sql-template-tags, the esbuild script needed to transpile the sql-template-tags package, here we transpile all packages except for sqlite3 which has some deep dependencies that aren't listed in its dependencies NPM packages. Thankfully the sqlite dependencies work with the transpiled app + other dependencies alright.
A shim function prepare was created to bridge the gap between the sql object format that db/sqlite3 expects and the sql format that sql-template-tags provides, which is a little different.
this PR switches out
sql-template-stringsforsql-template-tagsto allow for easier SQL query nesting and reusing of abstracted sub-queries.To use the ESM-only package
sql-template-tags, theesbuildscript needed to transpile thesql-template-tagspackage, here we transpile all packages except forsqlite3which has some deep dependencies that aren't listed in its dependencies NPM packages. Thankfully thesqlitedependencies work with the transpiled app + other dependencies alright.A shim function
preparewas created to bridge the gap between thesqlobject format thatdb/sqlite3expects and thesqlformat thatsql-template-tagsprovides, which is a little different.