> On Mar 28, 2024, at 9:39 PM, M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:
>
> I could not follow JSON part. Do you have any case where I can see JSON is used to solve this type of problem.
To get json back, take any query and wrap it in
'select array_to_json(array_agg(row_to_json(t)))::text from (' || query || ') as t;'
