By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SET @qwe='[{"name":"vasya","age":123},{"name":"kirill","age":321}]';
SELECT *
FROM json_table(
@qwe,
'$[*]' COLUMNS(
imya VARCHAR(10) path '$.name',
vozrast INT path '$.age'
)
) AS qwe;
| imya | vozrast |
|---|---|
| vasya | 123 |
| kirill | 321 |