3 ms·
It's still so weird to me that SQLite returns it's internal format to callers. create table foo (bar); insert into foo (bar) values ('{"answers": [42]}
by yencabulator 3y ago
It's still so weird to me that SQLite returns it's internal format to callers.
create table foo (bar);
insert into foo (bar) values ('{"answers": [42]}');
select jsonb_extract(bar, '$.answers') from foo;
;#42