Will the database have its own page much like what Notion has?

You can create a page for a database entry manually. In the primary key, click more > new page, it will auto populate the page name based on the entry.

Thanks! Now I understand!

Actually, multi-view functionality is already supported now. You can simply create a new view on the duplicated database.

Could we implement a modal view feature for pages in the future, similar to Notion? Users would have the option to view page in a modal format for a quick overview. If they prefer a more detailed view, they can open it in a new tab.