Thanks! Lots of little neat improvements in there like accessing JSON values using dots and array syntax:

    SELECT t.j.foo.bar[2], ... FROM tbl t ...