如何快速处理数组对象遍历？

[junyao]

mongo cdc同步到paimon，通过paimon catalog发现都是字符串，并且数组ObjectId会被转换成下面

[{"$oid":"5eba3dad3caa67a1bd3ac341"},{"$oid":"62d0daa64eedf2271f204ff2"}]

如何在starrocks里面处理成

 ["5eba3dad3caa67a1bd3ac341","62d0daa64eedf2271f204ff2"]

[junyao]

SELECT
get_json_string ( ‘[{"$oid":“5eba3dad3caa67a1bd3ac341”},{"$oid":“62d0daa64eedf2271f204ff2”}]’, “$[*].$oid” );