is there JSON_ARRAYAGG in drizzle?

[skelawsky]

can it be done in drizzle way?

SELECT
    countries.id AS country_id,
    countries.name AS country_name,
    JSON_ARRAYAGG(
        JSON_OBJECT(
            'city_id', cities.id,
            'city_name', cities.name,
            'country_id', cities.countryId,
            'popularity', cities.popularity
        )
    ) AS cities
FROM
    countries
LEFT JOIN
    cities ON countries.id = cities.countryId
GROUP BY
    countries.id, countries.name;

[arily]

I think this would be relatively easy since drizzle already using JSON_ARRAYAGG in relational queries.

drizzle team please 🙏

[kravetsone]

I think this would be relatively easy since drizzle already using JSON_ARRAYAGG in relational queries.

drizzle team please 🙏

Just use sql`` or find an utils at drizzle.run

[hoffnung8493]

https://drizzle.run/p9u6g3z67goqmeyrljf0k2dj this looks like a good solution. Found this in drizzle.run!