目前达梦手册里面未查询到有可以直接将查询的数据转为json格式的函数。达梦提供了json_value和json_query两个函数。详细内容可参考《DM8_SQL语言使用手册.pdf》手册，第 18 章 JSON。

create table TEST6 (ID int,INFO varchar(100));
insert into TEST6 values (1,'{"db_name":"DM","edition":"开发版"}');
insert into TEST6 values (2,'{"db_name":"DM","edition":"标准版"}');
insert into TEST6 values (3,'{"db_name":"DM","edition":"企业版"}');
insert into TEST6 values (4,'{"db_name":"DM","edition":"安全版"}');
select json_query(INFO,'$.edition' with wrapper) from TEST6;
select json_query(INFO,'$.*' RETURNING VARCHAR PRETTY WITH WRAPPER ERROR ON ERROR) FROM TEST6;