const { user_id } = router.query;

  useEffect(() => {
    fetchIt();
  }, []);

  async function fetchIt() {
    try {
      setLoading(true);
      const { data, error } = await supabase
        .from("posts")
        .select("title, created_by")
        .match({ created_by: user_id });
      setPosts(data);
      console.log({ posts: data });
      if (error) throw error;
    } catch (error) {
      console.log(error);
    } finally {
      setLoading(false);
    }
  }

js
const { data, error, status } = await supabase
        .from('rooms')
        .select('*, owner:profiles(nickname), opponent:profiles(nickname)');
    
hint    "By following the 'details' key, disambiguate the request by changing the url to /origin?select=relationship(*) or /origin?select=target!relationship(*)"
message    "More than one relationship was found for rooms and profiles"
details    [ {…}, {…} ]
0    Object { origin: "public.rooms", relationship: "rooms_opponent_fkey[opponent][id]", cardinality: "m2o", … }
origin    "public.rooms"
relationship    "rooms_opponent_fkey[opponent][id]"
cardinality    "m2o"
target    "public.profiles"
1    Object { origin: "public.rooms", relationship: "fk_profiles_rooms_opp[opponent][id]", cardinality: "m2o", … }
origin    "public.rooms"
relationship    "fk_profiles_rooms_opp[opponent][id]"
cardinality    "m2o"
target    "public.profiles"

supabase.auth.signIn

javascript
export const post = async (request, response) => {
    const { session, error } = await supabase.auth.signIn({
        email: request.body.get('email'),
        password: request.body.get('password'),
    });
    if (!error) {
        request.body = {
            event: 'SIGNED_IN',
            session: session,
        };
        supabase.auth.api.setAuthCookie(request, response);
        response.redirect(302, '/')
        return response;
    }
    return {
        headers: { Location: `/signin?error=${encodeURIComponent(error.message)}` },
        status: 302,
    };
};