Support for Conditional Inner Joins within Semi Join Operations

[michael-mue]

Currently, Relax does not support performing conditional inner joins within semi join operations. This limits the ability to retrieve records from table A where a condition is met in both A and B, while including only columns from A. Specifically, the following types of joins are not possible within Relax:

• ⋉ A.a = B.b (B): This semi join would include rows from A that satisfy the join condition with table B, but only retain the columns from A.

While conditional outer joins are possible, this operations is currently not supported.