Python Forum

How to get the SQL query information which is generated by SAP Business Object Report, using Python?

Number of Columns used in SELECT statement.
Number of Columns used in WHERE Condition
Number of Columns used in JOINS condition.
Table name of the column

Input Query:

Select s.sid,s.sname,d.deptname from student s, department d where s.did=d.did ;

Output:
Column name : SELECT WHERE JOIN Table
s.sid yes yes NO Student
s.name yes No No Student
d.deptname yes No No Department
s.did No yes No Student
d.did No yes No Department

Any suggestions/help on this much appreciated. Thank you!