I have a query with subqueries but I don't know how to implement it with 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