The fantastic package sqlglot permit exploring SQL ASTs in many dialects. I want to use it to retrace the lineage of all fields in a given query. I discovered that it’s not a trivial question, due to the SQL specification.