Yup - if you grab columns from multiple different connected tables (or schemas) the join will happen automatically for you and can be adjusted to different paths. This is actually a really hard problem, especially since 70% of datasources these days don't have foreign key information and we have to detect that automatically.

We also have the ability to with our visual language join data from multiple different queries/datasources. You can see how that happens here https://chartio.com/docs/visual-sql/merge-queries/