SELECT
games.name,
games.image_url,
JSON_AGG(
JSON_BUILD_OBJECT(
'name', game_features.name,
'icon_url', game_features.icon_url
)
) AS features
FROM
games
LEFT JOIN game_features ON games.id = game_features.game_id
GROUP BY
games.name,
games.image_url,
games.sort_order
ORDER BY
games.sort_order;
SELECT
games.name,
games.image_url,
JSON_AGG(
JSON_BUILD_OBJECT(
'name', game_features.name,
'icon_url', game_features.icon_url
)
) AS features
FROM
games
LEFT JOIN game_features ON games.id = game_features.game_id
GROUP BY
games.name,
games.image_url,
games.sort_order
ORDER BY
games.sort_order;