hasura/graphql-engine v2.0.0-alpha.3

on GitHub

Changelog

ltree comparison operators

Comparison operators on columns with ltree, lquery or ltxtquery types are now supported, for searching through data stored in a hierarchical tree-like structure.

See the documentation at graphql/core/queries/query-filters more details on the currently supported ltree operators.

Example query: Select ancestors of an ltree argument

query {
  tree (
    where: {path: {_ancestor: "Tree.Collections.Pictures.Astronomy.Astronauts"}}
  ) {
    path
  }
}

Example response:

{
  "data": {
    "tree": [
      {
        "path": "Tree"
      },
      {
        "path": "Tree.Collections"
      },
      {
        "path": "Tree.Collections.Pictures"
      },
      {
        "path": "Tree.Collections.Pictures.Astronomy"
      },
      {
        "path": "Tree.Collections.Pictures.Astronomy.Astronauts"
      }
    ]
  }
}

Bug fixes and improvements

• server/mssql: fix malformed JSON answer on empty tables
• server/mssql: fix runtime errors when selecting geography/geometry columns
• server/mssql: supports connection pooling to sql server
• server: improve errors messages for inconsistent sources
• server: better handling for one-to-one relationships via both manual_configuration and foreign_key_constraint_on (#2576)
• console: add relationship tab for mssql tables
• build: fix the packaging of static console assets (fix #6610)

Using this release

Use the following docker image:

hasura/graphql-engine:v2.0.0-alpha.3