PostgreSQL’s two popular functions JSON object builder and JSON aggregator are good when you want to fetch a list of child data along with the parent and pass that child data with the parent to the calling service.