Parameter order in read_sql makes switching out Pandas difficult

[Diego-Hernandez-Moodys]

Describe your feature request

I'd like the parameters to be in the same order as pandas.read_sql(query, connector) at best.

I currently can't simply replace pandas.read_sql with connectorx.read_sql due to the parameter order. You may close if parameter order in read_sql is different between the different libraries you aim to replace.

[wangxiaoying]

Hi @Diego-Hernandez-Moodys , thanks for the advice. We added a pandas aligned interface in this commit. You can replace pandas.read_sql as follow:

# from pandas import read_sql
from connectorx import read_sql_pandas as read_sql

read_sql(sql, con)