Hi,

example sql querie update:

def _execute_query(self, cr,id_object ):            
        sql ='''update  my_table_name
                 set state= 'failure'
                 where  id =  %s 
                 ''' % (id_object)                     
        cr.execute(sql)

It is not recommended to type SQL-queries directly from a field and use that to access the DB. Reason is that you can make mistakes and mes sup everything, or worse, you are vulnerable to SQL-injections.

The better way is to make your own modules, with fixed SQL, and optional some input, like the example of Borni DHIFI. Than install that module and use a button or dropdown to let users execute the query and/or fill in the needed variables.