Posted to tcl by oldlaptop at Sat Sep 24 16:40:23 GMT 2022view pretty
eltclsh > package require sqlite3
3.36.0
eltclsh > set ret {[{"id": 1, "foo": "spam"}, {"id": 2, "bar": "ham"}, {"id": 3, "baz": "egg"}]}
[{"id": 1, "foo": "spam"}, {"id": 2, "bar": "ham"}, {"id": 3, "baz": "egg"}]
eltclsh > sqlite3 parser :memory:
eltclsh > parser eval { select atom from json_tree(:ret) where atom not null and key <> 'id' }
spam ham egg
eltclsh >