That is the plan, yes.
I realise now that the upcoming feature may not deliver on this request.
Here’s a mockup of (which uses the outdated Creator terminology, but) which is indicative of where we’re probably heading.
When making someone an space `Architect’, you can choose whether to extend this to all of the data in the databases in the space.
An (unextended) Architect will be able to create/configure views and databases in the Space, but not see/manipulate any data (unless specifically granted access by some other means).