JSON_SERIALIZE

1
SELECT
2
  json_col,
3
  JSON_SERIALIZE(json_col) as serialized,
4
  TYPEOF(JSON_SERIALIZE(json_col)) as result_type
5
FROM (SELECT JSON('{"name": "Budi", "age": 30}') as json_col);

1
SELECT
2
  id,
3
  JSON_SERIALIZE(JSON_OBJECT(
4
    'id', id,
5
    'name', name,
6
    'email', email
7
  )) as json_line
8
FROM users;

1
SELECT JSON_SERIALIZE(JSON_OBJECT(
2
  'status', 'success',
3
  'data', JSON_OBJECT(
4
    'users', JSON_ARRAY(
5
      JSON_OBJECT('id', 1, 'name', 'Budi'),
6
      JSON_OBJECT('id', 2, 'name', 'Ani')
7
    )
8
  )
9
)) as api_response;