Hi. I am trying to build a Large JSON Object, and running into issues with the function limit on 100 arguments. I know I can use ARRAY[] to get around this, but I can't mix text and numeric types, which I need to do to have a nicely usable JSON object.
I know I can do this: json_build_object('somekey', 1.0, 'someotherkey', 2.0) but cannot put more than 100.
What I can't do is json_build_object(array['somekey', 1.0, 'someotherkey', 2.0]); (json_object() with the same error): invalid input syntax for type numeric: "somekey"
What I can do but don't want to do is json_object(array['somekey', '2.0', 'someotherkey', '2.0']) because you have a poorly typed JSON object that's less helpful downstream.