Better support for (Materialized) Views

Nowadays NoSQL db are very widespread because they're easy to use. One of the main key advantages is the ability to retrieve a graph/tree instead of doing a lot of JOINs in SQL. But there's an easy solution in SQL: views, and especially materialized views for better performance. Yet, in Supabase, views are not very well supported:

• no realtime support :
• no incremental updates extension support:
• less supported in Studio:

If the solution you recommend is not views but rather a dedicated flat table "One Big Table" or any other solution, it should be said somewhere in the docs.