案例：{“lx”: “20”,“pch”: “swry.jxlq.***||202303”,“aae002”: “202303”,“risks”:[{“riskcode”: “swry_all.jxlq.cxyl”}, {“riskcode”: “swry_all.jxlq.cxyl33”}]} 现要获取risks的[]内的个数进行循环，如何进行？ json_extract(v_json,‘$.risks[i]’) 而且，这种获取是报错的
https://eco.dameng.com/document/dm/zh-cn/pm/json
select count(1) from json_table( '{"lx": "20","pch": "swry.jxlq.***||202303","aae002": "202303","risks":[{"riskcode": "swry_all.jxlq.cxyl"}, {"riskcode": "swry_all.jxlq.cxyl33"}]}', '$.risks[*]' columns ( code varchar path '$.riskcode[*]') ) as jt1;
https://eco.dameng.com/document/dm/zh-cn/pm/json