F/sql join mode

Now the `mode` can be defined on the relationship or at runtime. Two tests.