SQLite 3.45

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select sqlite_version();

sqlite_version()

3.45.3

-- the JSONB binary format arrived in SQLite 3.45
create table doc (id int, body blob);
insert into doc values (1, jsonb('{"name":"ann","tags":["sql","db"]}'));

1 row affected

select id
     , body ->> '$.name' as name
     , json(body)        as readable
from doc;

id
name
readable

1
ann
{"name":"ann","tags":["sql","db"]}

-- string_agg() and concat() are also new in 3.45
select string_agg(name, ', ') as names
from (select 'ann' as name union all select 'bob');

names

ann, bob