Type hints in JSON Schema for blobs/clobs, etc.
As came up on demo day today, we should invest in hints and conventions for taps to inform targets about special data types.
Possibly use type=string
and format=sql-type:<clob/blob>
"There is a bias toward networking-related formats in the JSON Schema specification, most likely due to its heritage in web technologies. However, custom formats may also be used, as long as the parties exchanging the JSON documents also exchange information about the custom format types. A JSON Schema validator will ignore any format type that it does not understand."
https://json-schema.org/understanding-json-schema/reference/string.html?highlight=date%20time#format
Edited by AJ Steers