JSON_TYPE

1
SELECT
2
  JSON_TYPE('{"name": "John"}') as obj_type,
3
  JSON_TYPE('[1, 2, 3]') as array_type,
4
  JSON_TYPE('"hello"') as string_type,
5
  JSON_TYPE('123') as number_type;

1
SELECT JSON_TYPE('{"data": [1,2,3]}', '$.data');

1
SELECT
2
  id,
3
  CASE JSON_TYPE(value, '$.amount')
4
    WHEN 'BIGINT' THEN 'integer'
5
    WHEN 'DOUBLE' THEN 'decimal'
6
    ELSE 'unknown'
7
  END as amount_type
8
FROM transactions;