Comments - JSON_OBJECT

WARNING! JSON_OBJECT will flatten a sub JSON object/array if the key's value has conditional paths that return a non-JSON type: eg

SELECT 
	JSON_DETAILED(
		JSON_OBJECT(
			'key'
		, 
			IF(
				TRUE
			,
				JSON_ARRAY(1,2)
			,
				JSON_COMPACT('XXX')
			)
		)
	)

will return

{
    "key": 
    [
        1,
        2
    ]
}

but

SELECT 
	JSON_DETAILED(
		JSON_OBJECT(
			'key'
		, 
			IF(
				TRUE
			,
				JSON_ARRAY(1,2)
			,
				'XXX'
			)
		)
	)

will return

{
    "key": "[1, 2]"
}

because the JSON array has been flattened due to the competing path returning a string ... even though it will NEVER use that path.