{
  "code": 400,
  "msg": "OAuth state parameter missing"
}

ts
status:  {
  code: '42501',
  details: null,
  hint: null,
  message: 'new row violates row-level security policy for table "profiles"'
}

ts
const body = Object.fromEntries(await request.formData())

        /**
         * Passwords must match
         */
        if(body.password !== body.confirmPassword) {
            return fail(400, {
                error: "Passwords do not match",
            })
        }

        /**
         * Password must be at least 8 characters and max 32 characters
         * 
         */
        if(body.password.length < 8 || body.password.length > 32) {
            return fail(400, {
                error: "Password must be at least 8 characters and max 32 characters",
            })
        }

        /**
         * First name and Last name check
         */
        if(body.firstName === "" || body.lastName === "") {
            return fail(400, {
                error: "First and last name are required",
            })
        }


        const { data, error: err } = await locals.sb.auth.signUp({
            email: body.email as string,
            password: body.password as string,
        })
        if(data?.user == null){
            return fail(400, {
                error: "User creation failed",
            })
        }
        await createProfile(data?.user,body);

        async function createProfile(data: User, body: any){
            console.log(data.id)
            let f = "Bob"
            let l = "Smith"
            const { error, status } = await locals.sb
            .from('profiles').insert([{ id: data.id, full_name: (f + " " + l)}])
            console.log("status: ", error)

        }

getIntrospectionQuery({description: false})

sql
SELECT brand
FROM products
WHERE brand = "ABC"

js
return supabase
  .from("games")
  .select("*")
  .eq("is_active", true)
  .contains("players", [user.id])
  .then(...)

contains

js
return supabase
  .channel("game-channel")
  .on(
    "postgres_changes",
    {
      event: "*",
      schema: "public",
      table: "games",
      filter: `is_active=eq.true`,
    },
    (payload) => {
      console.log("Change received!", payload);
    }
  )
  .subscribe();

user_one

user_two

export const getFriendships = async () => {
  const { data, error } = await supabaseClient
    .from('friendships')
    .select('*, user_one(*), user_two(*)');

  if (error) {
    throw Error(error.message);
  }

  return data;
};

{
  "message": "No API key found in request",
  "hint": "No `apikey` request header or url param was found."
}

WHERE name LIKE $1

age=$1

uuid[]

sql
(uid() = ANY (players))

Error: new row violates row-level security policy for table "games"