Add template tags support to node:sqlite

[mcollina]

What is the problem this feature will solve?

I've created a small module https://github.com/mcollina/node-sqlite-tags to add template tags to our SQLite implementation.

What is the feature you are proposing to solve the problem?

Adding something similar to the module itself.

What alternatives have you considered?

No response

[mcollina]

cc @nodejs/sqlite

[geeksilva97]

+1

I can see the value in such a feature, and it has been requested in other packages out there.

Refs:

• feature: Add support for sql-template-strings WiseLibs/better-sqlite3#178
• Support sql`` JS template strings that create cached prepared statements WiseLibs/better-sqlite3#1157

[geeksilva97]

Do you see this as a new API just for working with tags, @mcollina, or would it be on top of the current api like below?

db.run`some query here`
db.all`some query`