query {
  post_by_pk(project_id: "some_uuid_for_post"){
    ifLiked: likes(where: {
      user_id: {
        _eq: "i_logged_in_with_this_uuid"
      }
    }) {
      id
    }
    likes(limit: 10) {
      user {
        name
        id
      }
    }
    total_like: likes_aggregate {
      aggregate {
        count
      }
    }
  }
}

public, private & email

sql
CREATE VIEW hidden_account_info as select email, employee_id, name from public.accounts;
CREATE POLICY "Hide protected account info from the public"
    on hidden_account_info
    for select
    using (
        id = auth.uid() OR -- ID Not found as not in the view
        is_account_admin(
            (SELECT * FROM public.accounts WHERE id = auth.uid())
        )
    );

sql
CREATE OR REPLACE FUNCTION f_hidden_account_info(user_id uuid)
RETURNS boolean as $$
declare
    account public.accounts := (SELECT * FROM public.accounts WHERE id = auth.uid());
begin
    IF account.id = user_id OR is_account_admin(account) THEN
        RETURN TRUE;
    ELSE
        RETURN FALSE;
    END IF;
end;
$$ stable language plpgsql security definer;

CREATE VIEW hidden_account_info as select email, employee_id, name from public.accounts;
CREATE POLICY "Hide protected account info from the public"
    on hidden_account_info
    for select
    using (f_hidden_account_info(auth.uid()));

function MyApp({ Component, pageProps }) {
  const [user, setUser] = useState(null);
  useEffect(() => {
    const { data: authListener } = supabase.auth.onAuthStateChange(async () =>
      checkUser()
    );
    checkUser();
    return () => {
      authListener?.unsubscribe();
    };
  }, []);
  async function checkUser() {
    const user = supabase.auth.user();
    console.log(user);
    setUser(user);
  }
  return (
    <Provider store={store}>
      <Layout>
        <Component {...pageProps} />
      </Layout>
    </Provider>
  );
}