New SQLClient API

[Jesus89]

Refactor cc.query feature. New class? new method?

Update

From the doc:

from cartoframes.client import SQLClient

sql_client = SQLClient(creds)
sql_client.query('select …') // Uses the SQL API
sql_client.execute('insert …')  // Uses the Batch SQL API

# Helpers (future)
sql_client.create_table(‘table_name’)
sql_client.distinct(‘table_name’, ‘column_name’)
sql_client.bounds(‘table_name’)

[simon-contreras-deel]

I see 2 options:

• a function if it will only send queries to SQL API
• a new object if we add more features (custom queries) over the SQL API:
  • create table
  • cartodbfy table
  • call to that data services functions
  • ...

I am not sure about the second one, so I would say a function is enough, but maybe someone see more things based on the second one