Add more options to joins on question builder

It would be great to add two more options on join conditions using question builder.

1 - Use different logic operators such as OR and change logic priorities using ()
Ex: (X=Y or Z=U) and R=E

2 - Add the use of fixed values on join conditions
Ex: X='TEST' and Z = Y
Add the TEST filtering on filtering will get the unmatched records of left/right joins out of the results while filtering on join conditions would display the unmatched records.

Hi @drconstantino
There's requests for more options:
https://github.com/metabase/metabase/issues/19443 - upvote by clicking :+1: on the first post
It is possible to use a static value on join by using a Custom Column. For strings, you would use concat.