Return Single Object Instead of Array?

[chauhankiran]

Consider the following query.

  return await sql`
    select
      *
    from users
    where
      email = ${email} and password = ${password}
  `;

This will return a single user.

And there always be scenario where we're interested to fetch only single row than multiple row results. So, it there a way that we can only return just a single object ({}) instead array of object ([{}])? As of now, I need to write like user[0].id instead of user.id.

[porsager]

Destructuring for the win 😉

const [user] = await sql`...`
// user.id

And if you don't want the temporary variable you can do destructuring in .then like this:

return await sql`...`.then(([x]) => x)

And going further a utility function is so simple to have that increasing the surface api of this library is not worth it:

const first = ([x]) => x

const user = first(await sql`...`)
// or
const user = await sql`...`.then(first)