By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with mytable as (select '{
"invoices": [{
"items": [{ "given_id": "TBC0003B" }]
}]
}' my_json_col)
select json_extract(my_json_col, '$.invoices[0].items[0].given_id') my_given_id from mytable
{ "code": "SQLITE_ERROR" }