How to build hasura graphql query with join for condition?

[V-ampire]

I have 2 tables with - users and users_ban, so I want to make graphql using hasura server query which fetch users and join boolean field either user in ban list, like in sql:

select 
id, 
email,
case
  when users_ban.id is null then false
  else true
end is_banned
from users
left join users_ban
on users.id = users_ban.user_id;

How can I do it via graphql and hasura server?

[SamirTalwar]

@V-ampire, have you tried computed fields?

[V-ampire]

Nope, I will look into it, but I'd like to find a way to avoid modify backed and fecth data using query only. Is this possible?

[SamirTalwar]

I suggest using native queries then.

[V-ampire]

I see, thanks, I thought it's possible to use only graphql queries