Joining logic is defined in our data modeling layer, either from Hashboard (our BI tool) or can also be defined in Hashquery as well instead of replying on your database schema for fk relationships. We went this route since a lot of people are using dbt generated tables.
Hashquery is a new toolkit for defining, importing, and executing your data models and business metrics.
Hashquery is capable of expressing complex, multi-layered data queries, way beyond the capabilities of standard SQL. It natively integrates with Hashboard, with more semantic layer integrations to come. And unlike a DSL, Hashquery is fully composable and extensible — it's just Python.
https://hashquery.dev/docs/pattern_guides/joins/