declarative json postgresql

holyshit.sql

    select row_to_json(q) from (
        select
            row_to_json(a) account
            , json_agg(t) trades
        from pm_account a
        left join lateral (
            select 
                row_to_json(t) trade
                , json_agg(d) dailies
                , json_agg(sf) smartorders
            from pm_trade t
            left join pm_tradedaily d
                on d.trade_id = t.id
            left join lateral (
                select 
                    row_to_json(pts) smartorder
                    , json_agg(ptf) fills 
                from pm_tradesmartorder pts
                left join pm_tradefill ptf
                    on ptf.trade_smartorder_id  = pts.id
                where pts.trade_id = t.id
                group by pts.*
            ) sf on 1 = 1	
            where t.account_id = a.id
            group by t.*
        ) t on 1 = 1
        group by a.*
    ) q

one can convert the following schema into the above sql (tree leaves are left join, tree branches are left join lateral)

pm_account
        |__ pm_trade (account_id)
                     |__ pm_tradedaily (trade_id)
                     |__ pm_tradesmartorder (trade_id)
                                    |__ pm_tradefill (trade_smartorder_id)