By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select t.id, v.value
from (values (23, '[1,2,3]'), (47, '[2,4,6]')) as t(id, arraylist)
cross apply openjson(t.arraylist) v
| id | value |
|---|---|
| 23 | 1 |
| 23 | 2 |
| 23 | 3 |
| 47 | 2 |
| 47 | 4 |
| 47 | 6 |