Feature: Support ES6 Tagged template literals about node-sqlite

[GregoryPotdevin]

I had the same idea a few days ago and thought it would need a babel preprocessor...
Would love to have this !

[wmertens]

In the meantime you can use

export const S = (strings, ...values) => [strings.join('?'), values]
db.all(...S`select * from foo where t = ${bar}`).then(...)

But the proposed approach is of course better. Would also be nice to have an id escape mechanism, since you can't pass e.g. table names as parameters. Options: either inline SELECT * FROM id${tableName} or through magic objects SELECT * FROM ${id(tableName)}. I think I prefer inline.

[tracker1]

@wmertens, would be better to use String objects for enhanced strings...

db.literal = str => Object.assign(new String(str), { literal: true });

then check for a .literal property on a String...

if (str intanceof String && str.literal)

But that would be more than a simple join, of course.

[wmertens]

True. More obvious, but more typing though ☺

[tracker1]

var id = db.literal;
...
db.all(`...  ${id(someTableName)} ...`)

Not too bad...

[theogravity]

Create a PR w/ unit tests and an updated readme on usage

[tracker1]

Will see if I can work on this soon... haven't been working with sqlite lately, so will need to create some test scenarios and get it working.