ChrisJaunes comments

Repositories
Issues
Comments

Results 3 comments of


                                            ChrisJaunes

How to extract columns name along with table name from complex query having subquery

You can use "splparse.parse" to parse this complex query, then you can iterate over tokens and get cloumns from "select token" and "from token". Note that it is handled according...

How to extract columns name along with table name from complex query having subquery

more, you can refer to https://github.com/andialbrecht/sqlparse/blob/master/examples/extract_table_names.py

How to extract columns name along with table name from complex query having subquery

If you need to extract the outermost columns, some modifications are required for example: ```python if __name__ == "__main__": sql = """SELECT "Gender" AS "Gender", "Ethnicity" AS "Ethnicity", count(*) AS...