Column-Level Lineage For A DB2 To BigQuery Migration
Written in SQL and JavaScript UDFs, it follows control flow, temp tables, variables and dynamic SQL back to the source columns, then grades each result PASS, CHECK or UNRESOLVED. Static checks catch risky statements before anything runs. Lineage analysis for 300+ stored procedures went from about a month to one or two days.
An LG Uplus project, so the code isn't public.