martijndeh/lego

A lightweight SQL (string) builder using ES6 template strings. Lego embraces SQL instead of adding yet another abstraction layer.

lego's Issues

Use Lego.raw with Arrays

When doing a query that has both dynamic values and dynamic column names, things get a bit hairy.

Here's an example

const params = {
  age: 10,
  name: 'Bob'
}

await Lego.sql `UPDATE users SET ${Object.keys(params).map(key => Lego.sql `${Lego.raw(key)} = ${params[key]}`)} WHERE id = ${id}`

This does not appear to work, though perhaps I am just not using the correct combination of Lego.sql and Lego.raw