There’s currently no way to Dynamically include all columns in JSON_OBJECT() without manually listing them in the SQL query. However, Scalar function JSON_OBJECT not supported for stream fields
ex: SELECT JSON_OBJECT(t) FROM TABLE t / SELECT JSON_OBJECT(*) FROM TABLE t/ SELECT row_to_json(t) FROM TABLE t
Having this capability would be especially useful in SQL queries, as it would simplify working with JSON.
Thank you for submitting an idea for the Ideas contest. The status changed to "Ideas Contest".
Please answer the experts' clarifying questions, if any, during the contest and voting period.
