The JSON_TABLE table operator produces output rows which conform to the row format defined by the column_expr_literal. That literal describes the columns in the output row and their data types.
The rows returned by JSON_TABLE have the following columns:
- The first column returned contains the JSON document ID obtained from the first column in the json_documents_retrieving_expression.
- The next N columns returned are generated based on the colexpr parameter, where N is the number of objects in the JSON array represented by the column_expression_literal.
- If json_documents_retrieving_expr returns more than two columns, all the extra columns from the third column onward are added to the output row without being modified.