Tengo una consulta con subconsultas pero no se como implementarla con typeorm.
SELECT DISTINCT r.id, r.`name`, r.description, ( SELECT JSON_ARRAYAGG( state.`name` ) FROM region_state INNER JOIN state ON region_state.state_id = state.id WHERE region_id = r.id ) AS states FROM region r INNER JOIN region_state rs ON r.id = rs.region_id INNER JOIN state s ON s.id = rs.state_id