DT
Drizzle Team•3d ago
stumpykilo

Magic sql'' operator concat

I'm getting a strange error when I try to use concat with the sql operator. I'm getting error: column " " does not exist when running this query: 
  const result = await db.query.user.findMany({
    columns: {
      id: true,
      firstName: true,
      lastName: true,
      email: true,
    },
    extras: {
      fullName:
        sql<string>`concat(${user.firstName}, " ", ${user.lastName})`.as(
          "full_name",
        ),
    },
  });
  const result = await db.query.user.findMany({
    columns: {
      id: true,
      firstName: true,
      lastName: true,
      email: true,
    },
    extras: {
      fullName:
        sql<string>`concat(${user.firstName}, " ", ${user.lastName})`.as(
          "full_name",
        ),
    },
  });
Any ideas?
1 Reply
stumpykilo
stumpykiloOP•3d ago
I had to change the " " to ' ' Y'all may want to update the example: https://orm.drizzle.team/docs/rqb#include-custom-fields

Did you find this page helpful?