eg:

cr.execute('select * from res_partner')
fetch =  cr.dictfetchall() or cr.fetchall()

or you can simply execute as

query = "your query"
cr.execute(query)

use execute method

 cr.execute(sql_statment)