Help to Parse complex SQL queries

Question

Hello Community.

I am currently building a workflow, that "scans" other .yxmd workflows for inputs and outputs.

For many inputs its somewhat straightforward to parse out what fields are being input from the source.

But when it comes to database inputs where complex SQL queries are used it becomes very difficult.

Do you know of any resources or tools to parse SQL queries into which columns are being input from which tables?

Currently i can parse simple "select table.x from schema.xxxxx" by using regex. 
When the SQL query consists of several nested layers of select statements it becomes a whole different scenario.

Ideally i am hoping that there is some python code or macro that i can read the sql code into, which then outputs tables and columns.

All help will be greatly appreciated!

Best Regards

csheaffer1 · Answer

would you be able to share the parsing tools you reference? this is exactly what i am looking for. Thank you in advance!

preston_vock · Answer

Hello,

Could you share those tools? I am interested in parsing some existing sqls so that I can update the naming convention as we will be upgrading databases here shortly.

GloriousWater · Answer

First of all sorry for the slow response. I was occupied by higher priorities, however i will return to this once opportunity presents. I will update once so. In the meantime thank you very much for your inputs!