Re datetime filters:

If the datetimes are ISO formatted strings, would regex matching not work for basic filtering?

    where json_field.datetime similar to '2016-07-.*'

Of course, it'll probably be slow-tastic, and less convenient than native datetime manipulation, but hey, maybe it's enough to get unblocked?