There's table valued functions over json as well, as mentioned by [1].

https://sqlite.org/json1.html#table_valued_functions_for_par...

[1] https://news.ycombinator.com/item?id=47618597