const productItemsImagesSQLAgg = sql<ProductItemImages[]>`
COALESCE(
JSON_AGG(
JSON_BUILD_OBJECT(
'url', ${images.url},
'key', ${images.key}
)
) FILTER (WHERE ${images.id} IS NOT NULL),
'[]'::JSON
)
`.as('images');
const productItemsImagesSQLAgg = sql<ProductItemImages[]>`
COALESCE(
JSON_AGG(
JSON_BUILD_OBJECT(
'url', ${images.url},
'key', ${images.key}
)
) FILTER (WHERE ${images.id} IS NOT NULL),
'[]'::JSON
)
`.as('images');