Desiging and creating Views

Dear Community,

I want to propose adding the ability to design views based on the existing tables with the different join options.

Something like:

View view_group_roles [orderby:group_name]{
id Group.id
id Role.id
group_name Group.name
role_name Role.name
left_join [on: Group.id = Role.group_id]
}