Joins

[Forceres]

Is it possible to use joins without fully raw query? Or is here a way to build raw queries without hard coding?

[dantownsend]

Joins are handled automatically, but you can use join_on if you want to join on something without a primary key, or do a reverse join:

https://piccolo-orm.readthedocs.io/en/latest/piccolo/query_types/joins.html#join-on

[Forceres]

Ended with implementing my own joins builder, the absence of reverse look up relationships forced to do it