Computed fields¶

What are computed fields?¶

Computed fields are virtual values or objects that are dynamically computed and can be queried along with a table’s columns. Computed fields are computed when requested for via custom SQL functions using other columns of the table and other custom inputs if needed.

Computed field types¶

Based on the SQL function’s return type, we can define two types of computed fields:

CREATE FUNCTION author_full_name(author_row author)
RETURNS TEXT AS $$
  SELECT author_row.first_name || ' ' || author_row.last_name
$$ LANGUAGE sql STABLE;

query {
  author {
    id
    first_name
    last_name
    full_name
  }
}

CREATE FUNCTION filter_author_articles(author_row author, search text)
RETURNS SETOF article AS $$
  SELECT *
  FROM article
  WHERE
    ( title ilike ('%' || search || '%')
      OR content ilike ('%' || search || '%')
    ) AND author_id = author_row.id
$$ LANGUAGE sql STABLE;

query {
  author {
    id
    first_name
    last_name
    filtered_articles(args: {search: "Hasura"}){
      id
      title
      content
    }
  }
}

Adding a computed field to a table¶

Console

API

Head to the Modify tab of the table and click on the Add button in the Computed fields section:

Supported from

Console support is available in v1.1.0 and above

A computed field can be added to a table using the add_computed_field metadata API

Computed fields permissions¶

Access control to computed fields depends on the type of computed field.

• For scalar computed fields, permissions are managed similar to the columns permissions of the table.
• For table computed fields, the permissions set on the return table are respected.

Accessing Hasura session variables in computed fields¶

It can be useful to have access to the session variable from the SQL function defining a computed field. For instance, suppose we want to record which users have liked which articles. We can do so using a table article_likes that specifies a many-to-many relationship between article and user. In such a case it can be useful to know if the current user has liked a specific article, and this information can be exposed as a Boolean computed field on article.

Create a function with an argument for session variables and add it with the add_computed_field API with the session_argument key set. The session argument is a JSON object where keys are session variable names (in lower case) and values are strings. Use the ->> JSON operator to fetch the value of a session variable as shown in the following example.

-- 'hasura_session' will be the session argument
CREATE OR REPLACE FUNCTION article_liked_by_user(article_row article, hasura_session json)
RETURNS boolean AS $$
SELECT EXISTS (
    SELECT 1
    FROM article_likes A
    WHERE A.user_id = hasura_session ->> 'x-hasura-user-id' AND A.article_id = article_row.id
);
$$ LANGUAGE sql STABLE;

POST /v1/query HTTP/1.1
Content-Type: application/json
X-Hasura-Role: admin

{
    "type":"add_computed_field",
    "args":{
        "table":{
            "name":"article",
            "schema":"public"
        },
        "name":"liked_by_user",
        "definition":{
            "function":{
                "name":"article_liked_by_user",
                "schema":"public"
            },
            "table_argument":"article_row",
            "session_argument":"hasura_session"
        }
    }
}

query {
  article(where: {id: {_eq: 3}}) {
    id
    liked_by_user
  }
}

Computed fields vs. Postgres generated columns¶

Postgres, from version 12, is introducing Generated Columns. The value of generated columns is also computed from other columns of a table. Postgres’ generated columns come with their own limitations. Hasura’s computed fields are defined via an SQL function, which allows users to define any complex business logic in a function. Generated columns will go together with computed fields where Hasura treats generated columns as normal Postgres columns.