sqliteBuilder: Opinionated safe(r) query builder using tagged templates

Create val
import { Statement } from "https://esm.town/v/postpostscript/sqliteBuilder";

const unsafeId = "1234 or TRUE"

console.log(Statement`
SELECT *
FROM table
WHERE id = ${unsafeId}
${Statement`AND other_`}
`)
// StatementInstance {
//   sql: "\nSELECT *\nFROM table\nWHERE id = ?\nAND otherCondition\n",
//   args: [ "1234 or TRUE" ],
//   log: false
// }


const results = await Statement`SELECT ...`.execute()
// [ { key: "value", anotherKey: "anotherValue" }, ... ] 

Or you can pass it directly to @std/sqlite.execute:

Create val
import { sqlite } from "https://esm.town/v/std/sqlite"

await sqlite.execute(Statement`Select ...`) 

You can combine multiple statements using Statement.prototype.combineWith:

Statement`...`.combineWith(Statement`...`, " AND ")
[
  Statement`fieldA`,
  Statement`fieldB`,
  Statement`fieldC`,
].reduce((a, b) => a.combineWith(b, ", "))