select id
from json_table(json_array(1,2,3,4 returning blob)
  format json, '$[*]'
columns (
  id number path '$'));