CODE EXAMPLE FOR PYTHON

write custom query odoo

 self.env.cr.execute("your query goes here ")
values = self.env.cr.dictfetchall() // here you will get the values
 for index in range(0, len(values)):
                print(f"

 {values[index].get('key_name')}  

")