如何在odoo中存储和执行SQL查询，并使用字段列表创建新的模型？

from odoo import models, fields, api

class CustomModel(models.Model):
    _name = 'custom.model'
    _description = 'Custom Model'

    # Define fields to store query results
    field1 = fields.Char(string='Field 1')
    field2 = fields.Integer(string='Field 2')

    @api.model
    def create_model_from_sql_query(self):
        # Execute SQL query
        self.env.cr.execute("SELECT field1, field2 FROM table_name")

        # Fetch query results
        results = self.env.cr.fetchall()

        # Create records in the custom model
        for result in results:
            self.create({
                'field1': result[0],
                'field2': result[1],
            })