MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

10.6.27-MariaDB-deb11

-- JSON_TABLE arrived in MariaDB 10.6
select *
from json_table('[{"name":"ann","age":34},{"name":"bob","age":28}]'
  , '$[*]' columns (name varchar(10) path '$.name', age int path '$.age')) as people;

name
age

ann
34

bob
28

-- FETCH ... WITH TIES also arrived in 10.6: both 1s stay
select x from (select 1 as x union all select 1 union all select 2) t
order by x fetch first 1 rows with ties;

x

1

1