TD_JSONSHRED returns a derived table with rows that have at least two columns:
- The first column is the indentifier column that was retrieved by the json_documents_retrieving_expression. It is passed through, unchanged, from the results of that retrieving expression query.
- The last columns returned are from the shredded JSON data, and must conform to the format and data types defined by COLEXPR and RETURNTYPES.
- If the original json_documents_retrieving_expr returned additional columns between the ID and JSON data columns, these pass-through columns are returned unmodified between the ID column and the columns of shredded JSON data.