Looking the record Tblob I was thinking of have a new type of field for JSON DB fields that can expose a TJsonObject instance with its data, if loaded.
For the moment I am using a Tblob and a separate not mapped record in the entity class that reads the blob field and provides the TJsonObject (Managed records are very helpful). Is it possible to "register" this new TJsonfield to use it as we do with Tblob? Having a Tcustomfield managed record that can create-manage-expose any kind of user defined class inside it, can be also very helpful and use a BLOB or JSON field in the database.
A Tcustomblob record available only to last Delphi versions that support managed records can include a TObject variable and anonymous procedures to be set for Initialization/finalization of the record(for the Tobject variable) and import/export of data to deal with the FIntData Tarray when loading/saving.
I am evaluating also the Linq.Sql for querying Json Pairs inside the DB's JSON field. But it is limited to Aurelius and not available to Xdata Crud endpoints as I can understand.
Thank you in advance