Add Lineage Information to EXPLAIN (TYPE IO)

[shohamyamin]

Description:

Currently, the Trino EXPLAIN command does not return lineage information. As discussed, this feature would be highly beneficial for understanding the dependencies of a query without needing to configure additional event listeners such as the Trino-openlineage plugin.

Use Case:

This enhancement would allow users to understand table dependencies directly from the EXPLAIN output.
It would eliminate the need to configure and use additional plugins for lineage information in many cases.
This feature would be especially useful for users who need to analyze or debug SQL queries without executing them.
Related Discussion:

References:

Original Discussion in Slack

Tagging:

@findepi
@ebyhr
@praveen

[predator4ann]

Hi, does anyone pick this? If not, I'm happy to try.