db-helper.ts

import type * as sqlite3 from "sqlite3";

export interface ParameterizedQuery {
	sql: string;
	params?: any;
}

export function sql(
	parts: readonly string[],
	...params: any[]
): ParameterizedQuery {
	return {
		sql: parts.join("?"),
		params,
	};
}

async function run(
	db: sqlite3.Database,
	query: ParameterizedQuery
): Promise<sqlite3.RunResult> {
	return new Promise((resolve, reject) => {
		db.run(query.sql, query.params, function (err) {
			if (err) return reject(Error(err.message));
			resolve(this);
		});
	});
}

main.ts

import * as sqlite3 from "sqlite3";
import {run} from "./db-helper.js";

const db = new sqlite3.Database("./db.sqlite");
const { lastID } = await run(
	db,
	sql`
		INSERT INTO reminders 
		(author_id, iso8601, text)
		VALUES 
		(${author_id}, ${iso8601}, ${text});
	`,
);

@surma "?" what's this delimiter for? "NNNth-parameter" and it will work with number between 1 to SQLLITE_MAX_VARIABLE_NUMBER

@surma got it, https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals#tagged_templates Where is my head, I totally forget about tagged template, foundation of lit-html using ECMA tagged string template