@jys9962/safe-sql
v1.0.1
Published
sql builder
Readme
const { sql, params } = SQL`SELECT * FROM members where id = ${1}`;
console.log(sql); // SELECT * FROM members where id = ?
console.log(params); // [1]const subQuery = SQL`SELECT * FROM members where id = ${1} `;
const { sql, params } = SQL` SELECT * FROM (${subQuery}) where name = ${'name'} `;
console.log(sql); // SELECT * FROM (SELECT * FROM members where id = ?) where name = ?
console.log(params); // [1, 'name']