Extract parameters like table name, columns etc. from sql string

Question

I need to extract parameters like table names, selected columns and WHERE-statements for a given SQL string in Python 3. Is there a a library, that can do this and could I get an example for my case? Something like:

sql = 'select cola, colb, colc from "someschema"."mytable" where id = 1'
result = sqlparse(sql)
print(result.columns)
>> ["cola","colb","colc"]

print(result.tables)
>> ["mytable"]

If the question is not clear: The same question was asked before for C# extract column names and table name from any "SQL query" String

Ivan Sudos · Accepted Answer · 2019-04-02 12:27:37Z

3

You can use sqlparser

The example with table names extraction is here: https://github.com/andialbrecht/sqlparse/blob/master/examples/extract_table_names.py

The example with columns extraction is here: https://github.com/andialbrecht/sqlparse/blob/master/examples/column_defs_lowlevel.py

answered Apr 2, 2019 at 12:27

Ivan Sudos

1,4832 gold badges15 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extract parameters like table name, columns etc. from sql string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related