There Should be a Way to Define Joins at the Business Schema Level

[IamtheLaw382]

Some of the new business schema options are really useful!  The PostgreSQL option, in particular, is fantastic!

Unfortunately, developers are somewhat limited in what we can do with these as they basically come into the business view as a flat table without any way to define joins to other tables.  The problem is that if we want to use this in conjunction with other data within a dashboard, it becomes very difficult to filter the entire dashboard as any insights using the postgreSQL business view won't be affected by the dashboard filters (or vice versa).  

I think that having some sort of an additional layer that basically allowed you to define join paths without having to edit at the physical schema level would be very beneficial and also allow for more robust security.