Data Lineage Mapper from SQL Prompt

From the SQL below, trace the lineage of the output column {{output}}.
List every upstream table and column it depends on, in order.
Flag any upstream column that is derived from another transform (note the dependency chain).
Then state which source a data-quality issue would surface in first if it broke.

SQL:
```sql
{{sql}}
```

Replace the {{fields}} with your own context and tighten the rules to match your domain.