I need to create a table style view that has separate columns for each field of each instance (delta) of a field collection. I was able to implement this by copying from the references module. See http://drupalcode.org/project/references.git/blob/refs/heads/7.x-2.x:/vi... for an example.
I haven't written a patch because I couldn't figure out how to get views to load the file for my new handler, so I just stuck it directly in the existing field_collection.views.inc file. I might try again later and submit a patch.
My use case is this: I am setting up a sports league management system and I have a content type of match. I have a field collection of team and the team has team name, score and a checkbox for if the team forfeited or not. The field collection has a max delta of 2 so basically I would have a relationship for delta 1 called "home team" and a relationship for delta 2 called "away team".
PASSED: [[SimpleTest]]: [MySQL] 80 pass(es). View
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch 1208346-field_collection_views_relation_delta.patch. This may be a -p0 (old style) patch, which is no longer supported by the testbots. View