bug_list

Column Type
test_case_id BLOB
bug_id BLOB

SQL DDL

CREATE VIEW bug_list AS
 SELECT test_case_id,
 value as bug_id
    FROM test_cases, json_each(test_cases.bug_list)
;