I have been working with SQLite’s JSON1 extension and have noticed that while there are jsonb_ variants for nearly all json_ functions, the jsonb_each function seems to be missing.

Here is the documentation: https://www.sqlite.org/json1.html

I have a jsonb column my_data that looks like this: [{"key1": "value1"}, {"key1": "value2"},...].

Let’s say I want to find all key1 values using this query:

SELECT 
    j.value ->> 'key1' as key1
FROM 
    table1,
    json_each(table1.my_data) as j

Is j.value a json or a jsonb object here? Why is there no jsonb_each in SQLite?