为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8.1
【操作系统】：
【CPU】:
【问题描述】*：原本mysql使用JSON_ARRAY_APPEND拼接json数组，但是达梦不支持
原sql
update acm_app_action set config_schema=JSON_SET(config_schema, '$.sub_params', JSON_ARRAY_APPEND(config_schema->'$.sub_params','$',JSON_OBJECT('description', '自定义应答成功的判定条件，内置应答变量response', 'display_name', '应答成功判定', 'multi_valued', false, 'mutability', 'readWrite', 'name', 'successExp', 'page_control', 'JSON', 'required', false, 'type', 'STRING', 'update', true, 'value', 'response.status_code==200', 'value_type', 'FIX_VALUE'))) where protocol in('LOOP_HTTP','LEVEL_HTTP','HTTP');

替换达梦sql
update
"acm"."acm_app_action" aaa
set
aaa.config_schema =
json_set(aaa.config_schema, '$.sub_params',
json_concat(
json_value(aaa.config_schema ,'$.sub_params'),
json_object('description', '自定义应答成功的判定条件，内置应答变量response', 'display_name', '应答成功判定', 'multi_valued', false, 'mutability', 'readWrite', 'name', 'successExp', 'page_control', 'JSON', 'required', false, 'type', 'STRING', 'update', true, 'value', 'response.status_code==200', 'value_type', 'FIX_VALUE')
)
)
where aaa.protocol in
( 'LOOP_HTTP','LEVEL_HTTP','HTTP');

config_schema={"name": "root", "type": "OBJECT", "ui_id": "1847173075261693954", "update": true, "required": false, "mutability": "readWrite", "sub_params": [{"name": "httpMethod", "type": "STRING", "ui_id": "1802915904329203714", "update": true, "required": true, "mutability": "readWrite", "value_type": "FIX_VALUE", "description": "", "display_name": "请求类型", "multi_valued": false, "page_control": "SELECT", "option_values": ["GET", "POST", "PUT", "PATCH", "DELETE"]}, {"name": "endpoint", "type": "STRING", "ui_id": "1802915904329203715", "update": true, "required": true, "mutability": "readWrite", "value_type": "ADAPTOR", "description": "请填写完整的接口地址", "display_name": "请求地址", "multi_valued": false, "page_control": "TEXT"}, {"name": "contentType", "type": "STRING", "ui_id": "1802915904329203716", "value": "application/json; charset=UTF-8", "update": true, "required": true, "mutability": "readonly", "value_type": "FIX_VALUE", "description": "", "display_name": "请求体类型", "multi_valued": false, "page_control": "LABEL"}, {"name": "header", "type": "OBJECT", "ui_id": "1802915904329203717", "update": true, "required": false, "mutability": "readWrite", "value_type": "JS_EXP", "description": "", "display_name": "Header参数", "multi_valued": false, "page_control": "EXTEND_OBJ"}, {"name": "path", "type": "OBJECT", "ui_id": "1718683627745", "update": true, "required": false, "mutability": "readWrite", "value_type": "JS_EXP", "display_name": "Path参数", "multi_valued": false, "page_control": "EXTEND_OBJ"}, {"name": "query", "type": "OBJECT", "ui_id": "1802915904329203718", "update": true, "required": false, "mutability": "readWrite", "value_type": "JS_EXP", "description": "", "display_name": "Query参数", "multi_valued": false, "page_control": "EXTEND_OBJ"}, {"name": "body", "type": "OBJECT", "ui_id": "1802915904329203719", "update": true, "required": false, "mutability": "readWrite", "value_type": "JS_EXP", "description": "请输入json格式的请求参数body", "display_name": "Body参数", "multi_valued": false, "page_control": "JSON"}, {"name": "successExp", "type": "STRING", "value": "response.status_code==200", "update": true, "required": false, "mutability": "readWrite", "value_type": "FIX_VALUE", "description": "自定义应答成功的判定条件，内置应答变量response", "display_name": "应答成功判定", "multi_valued": false, "page_control": "JSON"}], "value_type": "JS_EXP", "display_name": "root", "multi_valued": false, "page_control": "FIXED_OBJ"}