CREATE TABLE Table_1 (column_A varchar(20), column_B JSON);
INSERT INTO Table_1 (column_A , column_B )
VALUES
     ( 'Cell 1', '[{"id":1, "name":"abc"},{"id":2, "name":"xyz"},{"id":3, "name":null}]' ),
     ( 'Cell 2', '[{"id":4, "name":"test 1"},{"id":5, "name":null}]' ),
     ( 'Cell 3', '[{"id":4, "name":"test 1"},{"id":5, "name":"xyz"}]' );

SELECT * FROM Table_1;