# SQL parsing, defined with a sourced example

GLOSSARY, read 10 Nov 2026

**The short answer.** Reading the text of SQL statements to work out which columns feed which. A parser handles joins, aliases and nested queries without running the query. Its limits show up with dynamic SQL, wildcards and unusual syntax. Foundational builds an abstract syntax tree with the open-source SQLGlot parser and derives column lineage from it.

## Definition

Reading the text of SQL statements to work out which columns feed which. A parser handles joins, aliases and nested queries without running the query. Its limits show up with dynamic SQL, wildcards and unusual syntax.

## Example from a real tool

**Example.** Foundational builds an abstract syntax tree with the open-source SQLGlot parser and derives column lineage from it.

## Related terms

- [query log lineage](/glossary/query-log-lineage/): Lineage built from the history of queries a warehouse has already run.
- [runtime lineage](/glossary/runtime-lineage/): Lineage emitted by a job while it runs, describing the inputs and outputs of that specific run.
- [lineage graph](/glossary/lineage-graph/): The network of assets and the links between them that a lineage tool builds.

## Where to read more

- [The Lineage Depth Matrix](/matrix/)
- [All glossary terms](/glossary/)

## Sources

- docs.foundational.io/en/articles/9479381-sql-lineage.md: https://docs.foundational.io/en/articles/9479381-sql-lineage.md (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datalineagecompare.com/glossary/sql-parsing/
