Parsing Postgres array
Trying to parse a Postgres array coming back like this:
.mapWith doesn't work.
{ditchrider,ditchrider,ditchrider}. This is my query:.mapWith doesn't work.
{ditchrider,ditchrider,ditchrider}. This is my query:{ditchrider,ditchrider,ditchrider}db
.select({
userRole: user.role,
soureRole: sql`ARRAY_AGG(${sourceRole.sourceRole})`.as('sourceRole'),
})
.from(user)
.innerJoin(sourceRole, eq(user.id, sourceRole.userId))
.groupBy(user.id)
.where(eq(user.id, input.userId));