library/library_app/reports/library_book_report.py

from odoo import fields,models


class BookReport(models.Model):
    _name = 'library.book.report'
    _description = 'Book Report'
    _auto = False

    name = fields.Char('Title')
    publisher_id = fields.Many2one('res.partner')
    date_published = fields.Date()

    def init(self):
        self.env.cr.execute("""
            Create or Replace View library_book_report as
            (
                select * from library_book where active=True
            )
        """)