Did you tried this kind of syntax with " referencedTable" ?

const { data, error } = await supabase
        .from('friends')
        .select('recieved!inner(*), sent!inner(*)')
        .eq('accepted', true)
        .or(`id.eq.${user?.id}`, { referencedTable: 'sent' })
        .or(`id.eq.${user?.id}`, { referencedTable: 'receive' })