Yes, a view-only mode would work. Ideally it would not just be a static view, but would allow users to run some queries (perhaps constrained?) on the table, so

Yes, a view-only mode would work. Ideally it would not just be a static view, but would allow users to run some queries (perhaps constrained?) on the table, so they can get a list of their customers who ordered last quarter but not this quarter, for example, or other similar queries. But disallowing them from modifying the DB would be fine. Maybe limiting it to tables established by the Creator, and with a certain View/Dashboard arrangement, would work.