Skip to content

Assignments

Christoph Herrmann edited this page Oct 17, 2019 · 2 revisions
const user = { email: 'email', name: 'name' }

const result = await sql.query(sql`
  UPDATE users SET ${sql.assignments(user)} WHERE id = 'id'
`)

// text: UPDATE users SET ("email", "name") = ($1, $2) WHERE id = 'id'
// values: ['email', 'name']
Clone this wiki locally