Postgres json_agg
How can I create this equivalent using drizzle?
I cannot find any article in the docs.
select
p.id,
p.description,
p.name,
json_build_object(
'id',
b.id,
'name',
b.name
) as brand,
json_agg(
json_build_object(
'id',
v.id,
'name',
v.name
)
) as variant
from
product as p
inner join brand as b on b.id = p.brand_id
inner join product_variant as v on v.product_id = p.id
group by p.id, b.idselect
p.id,
p.description,
p.name,
json_build_object(
'id',
b.id,
'name',
b.name
) as brand,
json_agg(
json_build_object(
'id',
v.id,
'name',
v.name
)
) as variant
from
product as p
inner join brand as b on b.id = p.brand_id
inner join product_variant as v on v.product_id = p.id
group by p.id, b.idI cannot find any article in the docs.
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources
Similar Threads
Was this page helpful?
