Select values from all tables in a join

[simonscheurer]

What I always find daunting (albeit it should not be), is to select some properties from all vertices along a given traversal.
In SQL this is a very common operation. Joining a few tables and selecting values from each of the tables to create one simple result table that has values from all of the joined tables.

This is a very simple query highlighting this. The gremlin equivalent would be super helpful as template for all such queries

SELECT Products.ProductName, Categories.CategoryName FROM Products INNER JOIN Categories ON Categories.CategoryID = Products.CategoryID

Of course this could be extended to

• Include three or more tables
• Include there tables where one is aggregated (for example: productName, categoryName and sum(order))
• Include some where condition (same as above, but restricting to customers from one specific country)

This is currently one of the parts I struggle most. Traversal work nicely, where conditions, querying, etc. as well. But a simple statement to just select properties "along the way" seems more difficult than it should be.