add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable(
js json NOT NULL
,id INTEGER NOT NULL
);
INSERT INTO mytable(js,id) VALUES ('{"feature": 1}',123);
INSERT INTO mytable(js,id) VALUES ('{"features": 2}',223);
INSERT INTO mytable(js,id) VALUES ('{"feature": 3}',323);
INSERT INTO mytable(js,id) VALUES ('{"features": 4}',423);

select coalesce(js ->> '$.feature', js ->> '$.features') feature, id
from mytable
feature id
1 123
2 223
3 323
4 423