By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (value JSON)
SELECT '[{"ID":11,"Change":true,"Painted":false},{"ID":22,"Change":false,"Painted":true}]' value;
Records: 1 Duplicates: 0 Warnings: 0
SELECT jsontable.num, jsontable.id, jsontable.change, jsontable.painted
FROM test
CROSS JOIN JSON_TABLE(test.value,
'$[*]' COLUMNS (num FOR ORDINALITY,
id INT PATH '$.ID',
`change` TEXT PATH '$.Change',
painted TEXT PATH '$.Painted')) jsontable
| num | id | change | painted |
|---|---|---|---|
| 1 | 11 | true | false |
| 2 | 22 | false | true |
SELECT JSON_EXTRACT(value, '$[*].ID')
FROM test
| JSON_EXTRACT(value, '$[*].ID') |
|---|
| [11, 22] |