Create a built-in native JSON datatype like "%Library.String" and implement the SQL JSON_ functions natively. Store, retrieve, search, validate by schema and update the before save and save JSON values instead of store into
%String - we can't store large size JSON due to maxlength(3 million chars) %Stream.GlboalCharacter - unable to utilize the JSON_TABLE or other SQL function directly(use substring to extract first and use JSON_TABLE).
This would be useful.
Thank you for submitting the idea. The status has been changed to "Needs review".
Stay tuned!