Filtering Users by Team Membership in Supabase Query

create table users (
  "id" serial primary key,
  "name" text
);

create table teams (
  "id" serial primary key,
  "team_name" text
);

create table members (
  "user_id" int references users,
  "team_id" int references teams,
  primary key (user_id, team_id)
);

this.supabase.client
  .from("users")
  .select("id, name, members!inner(teams(team_name))")
  .in("members.teams.team_name", ["Blue", "Yellow"])
  .then((res) => {});

this.supabase.client.from("users").select("*, teams(team_name)").in(
  "teams.team_name",
  ["Blue", "Yellow"],
).not("teams.team_name", "eq", [])
  .then(
    (res) => {},
  );

this.supabase.client
    .from("users").select("*, teams(team_name)").in(
      "teams.team_name",
      ["Blue"],
    ).then(
      (res) => {},
    );

[
  {"id":1,"name":"Anne","members":[{"teams": {"team_name": "Blue"}}]},
  {"id":2,"name":"Bob","members":[{"teams": {"team_name": "Yellow"}}]},
  {"id":3,"name":"Alice","members":[{"teams": null}]}
]

[
  {"id":1,"name":"Anne","members":["Blue"]},
  {"id":2,"name":"Bob","members":["Yellow"]},
  {"id":3,"name":"Alice","members":[]}
]