Postgres 13

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

create table t (
    mydata jsonb
);

INSERT INTO t VALUES
('{"bla_foo": {"status": 1}, "abc": {"status": 2}, "foo_blah": {"status": 3}}');

SELECT * FROM t

CREATE TABLE

INSERT 0 1

mydata

{"abc": {"status": 2}, "bla_foo": {"status": 1}, "foo_blah": {"status": 3}}

SELECT 1

SELECT
    *
FROM
    t,
    jsonb_each(mydata) objects

mydata
key
value

{"abc": {"status": 2}, "bla_foo": {"status": 1}, "foo_blah": {"status": 3}}
abc
{"status": 2}

{"abc": {"status": 2}, "bla_foo": {"status": 1}, "foo_blah": {"status": 3}}
bla_foo
{"status": 1}

{"abc": {"status": 2}, "bla_foo": {"status": 1}, "foo_blah": {"status": 3}}
foo_blah
{"status": 3}

SELECT 3

SELECT
    *,
    objects.value -> 'status'
FROM
    t,
    jsonb_each(mydata) objects
WHERE objects.key::text LIKE '%foo%'

mydata
key
value
?column?

{"abc": {"status": 2}, "bla_foo": {"status": 1}, "foo_blah": {"status": 3}}
bla_foo
{"status": 1}
1

{"abc": {"status": 2}, "bla_foo": {"status": 1}, "foo_blah": {"status": 3}}
foo_blah
{"status": 3}
3

SELECT 2

mydata	key	value
{"abc": {"status": 2}, "bla_foo": {"status": 1}, "foo_blah": {"status": 3}}	abc	{"status": 2}
{"abc": {"status": 2}, "bla_foo": {"status": 1}, "foo_blah": {"status": 3}}	bla_foo	{"status": 1}
{"abc": {"status": 2}, "bla_foo": {"status": 1}, "foo_blah": {"status": 3}}	foo_blah	{"status": 3}