basically allows for multi-level joins, pivots stuff like that