phiresky

    2019-12-23T12:00:00-02:00[America/Sao_Paulo]

    select users.*, orders.* from users left join orders on orders.user_id = users.id

    type SingleReturnRow = { users: {id: ..., }[], orders: {user_id: ..., id: ..., }[]}
    type Return = SingleReturnRow[]

    type SingleReturnRow = { user: User, orders: Order[] }

    select users.*, json_agg(orders.*) as orders from users left join orders on orders.user_id = users.id group by users.id