How to improve parameter selection and Email templates

Hello. I have two critical ideas for improving Parameter selection for example in Email Templates, especially the Macros.

Ability to JOIN datatypes on reverse relation.

Example: I am working with Email Template of type Order. I have no chance to included products of the order because the relation is this:

Order <-- Products in Order <-- Product

If u had ability to join Products in Order on OrderID and then Product on ProductID I could show it.

SQL Code would be:

SELECT * FROM Order
JOIN Products in Order AS PiO on PiO.OrderID = Order.OrderID
JOIN Product on Product.ProductID= PiO.ProductID

Then I could use the other tables data through join. Currently this is not possible as far as I can tell.

We should be able to join everywhere in bpm'online where we use the parameter-menu:

However it is possible to do JOIN on Printable tables and on Details:

To summarize: I can have foreign table data shown on Details and Printables. But not for example in Email Template. I believe this is very important