sql - PostgreSQL: How to create json using data from table

Question

i have table with column_name and json_path to extract values from json.

table:

| column_name | json_path |
| ----------- | --------- |
| id | {request,id} |
| seller_firstname | {request,seller,firstName} |
| seller_lastname | {request,seller,lastName} |

Is it possible to use data from table as input to any of posrgres built-in functions to create json like this:

{"request":{"id":1,"seller":{"firstName":"John","lastName":"Doe"}}}

Answer 1

等待大神答复