ParentFull threadokigan·ES query is enormously verbose (and JSON formatting adds another layer) -- so SQL is not great but it is much more succinct than ES alternativeView on HN