0

Input SQL:

SELECT A.COL_1 , B.COL_1 , A.COL_2 FROM TB_A inner join TB_B on TB_A.COL2 = TB_B.COL3

Output of SQL should be:

Source Table:  
TB_A 
TB_B   
Mapping Of Column:  
TB_A -> COL_1  
TB_A -> COL_2 
TB_B -> COL_1
Improve this question
3
  • You need a formal SQL parser for this. Commented May 31, 2022 at 6:35
  • refer here. Commented May 31, 2022 at 6:37
  • @TimBiegeleisen Hi Tim, what does it mean by 'formal' SQL parser ? Isn't it possible to write a python script ? Thanks anyways Commented May 31, 2022 at 7:18
Related questions
0
sql nested select parsing
2
parsing SQL with python to find specific statements
1
Python: parsing SQL query
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.