Partial Select - Child array
I have a one-many relationship of recipe->comments. How do I get it to return the comments as an array?
const test = await db
.select({
...getTableColumns(recipe),
comments: getTableColumns(comment), // This should be an array
})
.from(recipe)
.leftJoin(comment, eq(recipe.id, comment.recipeId));
const test = await db
.select({
...getTableColumns(recipe),
comments: getTableColumns(comment), // This should be an array
})
.from(recipe)
.leftJoin(comment, eq(recipe.id, comment.recipeId));
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
