So If I am understanding your post here correctly, its just a case of having the correct deep link set up in the YAML file to know what to query from a Shot?
There was a post by Philip Scadding a while ago that really helped me wrap my head around some of the way SG links things. Filter tasks for step type (short_name)?
Specifically this part:
Essentially you can use it to navigate through entity fields by providing the {field}.{EntityType}.{field} and it is possible to go multiple levels deep.
What entity type is your Episode? If we assume its a simple int field like ID then something like this could work:
'sg_sequence.Sequence.sg_episode_field_code'
Edit: Sorry just re-reading my post, I am making the assumption that you’re querying from a Shot as a source here, but I might have misunderstood if you’re actually querying from a version?
Cheers
Justin