Skill: schema item grounding

[Case 2]

• Initial Environment: A correct table has already been selected, but the join path depends on specific foreign-key style columns. The agent must inspect relation fields instead of guessing them.
• Real Question: Return the rows that connect pets to owners through the ownership bridge table.
• Real Trajectory: Read the bridge table, identify the correct join columns such as pet identifiers on both sides, and write the join with those exact fields.
• Real Answer: A valid answer requires using the correct bridge-key columns rather than omitting or hallucinating the join keys.
• Why this demonstrates the capability: This demonstrates that grounding errors occur even after the correct table family is known. The failure is specifically column-level: the SQL breaks if the agent misses the key fields needed to connect the relations. That makes it an archetypal schema item grounding case.

Pipeline Execution Instructions

To synthesize data for this capability, you must strictly follow a 3-phase pipeline. Do not hallucinate steps. Read the corresponding reference file for each phase sequentially:

1. Phase 1: Environment Exploration Read the exploration guidelines to discover raw knowledge seeds: references/EXPLORATION.md

2. Phase 2: Trajectory Selection Once Phase 1 is complete, read the selection criteria to evaluate the trajectory: references/SELECTION.md

3. Phase 3: Data Synthesis Once a trajectory passes Phase 2, read the synthesis instructions to generate the final data: references/SYNTHESIS.md