我尝试选择json提取标量（inputdetails，“$tags”），但它返回错误。

以下是一些选项：

选项1:json

select  json_extract_scalar(inputdetails ,'$.ID') as ID
       ,json_extract(inputdetails ,'$.tags')      as tags

from    apidetails
;

ID   |       tags
-------+-------------------
 api-1 | ["tag-1","tag-2"]

选项2：数组（varchar）

select  json_extract_scalar(inputdetails ,'$.ID')                       as ID
       ,cast(json_extract(inputdetails ,'$.tags') as array(varchar))    as tags

from    apidetails
;

ID   |      tags
-------+----------------
 api-1 | [tag-1, tag-2]

选项3：分隔字符串

select  json_extract_scalar(inputdetails ,'$.ID')                                       as ID
       ,array_join(cast(json_extract(inputdetails ,'$.tags') as array(varchar)),',')    as tags

from    apidetails
;

ID   |    tags
-------+-------------
 api-1 | tag-1,tag-2