Nested Queries

Nested Queries are supported by using SQL Tag queries as variables of other SQL Tag queries.

const state = 'active'
const email = 'email'
const name = 'name'

const result = await sql.query(sql`
  SELECT * FROM users WHERE
    state = ${state}
    AND
    id = (${sql`SELECT id FROM users WHERE email = ${email} AND name = ${name}`})
`)

// text: SELECT * FROM users WHERE
//         state = $1
//         AND
//         id = (SELECT id FROM users WHERE email = $2 AND name = $3)
// parameters: ['active', 'email', 'name']