The idea is:
Add an object type to data tables for columns so it’s simpler to store json data
My use case:
some data from my object store changes rarely, but the queries add a lot of time to my workflows. I’m using data tables to effectively cache the data. However, I’m converting parts of the data into strings ($json.tostring) and storing it and then when I recall that data I’m converting it back to an object with .parsejson. This works really well, but ads a workflow branch for each top level object I need to store and ads compute.
I think it would be beneficial to add this because:
Simply storing json objects as an object, much like postgres, would make the data tables much simpler, fewer columns, and much easier to integrate into json-heavy API workflows.
Are you willing to work on this?
I’m willing to test it!