There's table valued functions over json as well, as mentioned by [1]. https://sqlite.org/json1.html#table_valued_functions_for_parsing_json_json_each_jsonb_ea

There's table valued functions over json as well, as mentioned by [1]. https://sqlite.org/json1.html#table_valued_functions_for_parsing_json_json_each_jsonb_each_json_tree_and_jsonb_tree_ https://sqlite.org/json1.html#table_valued_functions_for_par... [1] https://news.ycombinator.com/item?id=47618597 https://news.ycombinator.com/item?id=47618597