Query hierarchical data structures on Hasura with Postgres ltree

This post introduces support in Hasura 2.0 for queries on hierarchical data structures using Postgres ltree operators. Ltree is a Postgres extension that enables powerful search functionality and can be used to model, query, and validate hierarchical and arbitrarily nested data structures. The newly supported ltree comparison operators include _ancestor, _descendant, _matches, _matches_fulltext, and their *_any variants. These operators allow for efficient querying of hierarchical data in Hasura applications.