[FEA] Support for LeftAntiJoin in a BroacastNestedLoopJoin

[revans2]

Just for fun I tried to run the qualification tool using our plugin. It worked (no crashes), but there were large parts of it that couldn't run on the GPU.

We are missing support for LeftAntiJoin in a BroadcastNestedLoopJoin. This hopefully can work once we have AST support in the join, but might take some creativity because the expression being done for the join is.

@Expression <Or> ((sqlID#87L = sqlID#87L#18489L) OR isnull((sqlID#87L = sqlID#87L#18489L))) could run on GPU
  @Expression <EqualTo> (sqlID#87L = sqlID#87L#18489L) could run on GPU
    @Expression <AttributeReference> sqlID#87L could run on GPU
     @Expression <AttributeReference> sqlID#87L#18489L could run on GPU
   @Expression <IsNull> isnull((sqlID#87L = sqlID#87L#18489L)) could run on GPU
     @Expression <EqualTo> (sqlID#87L = sqlID#87L#18489L) could run on GPU
      @Expression <AttributeReference> sqlID#87L could run on GPU
      @Expression <AttributeReference> sqlID#87L#18489L could run on GPU

Because isNull is not a supported AST operation yet.

We need to support arrays of ints as a part of a BroadcastNestedLoopJoin (Sadly this looks like it is a part of the join and we would need to do an ArrayContains as a part of the join, which is also not a part of the AST.

[jlowe]

Support for nested loop anti joins was added in #3184. For this specific query the plugin does not yet support converting isnull to the AST, so I filed #4411 to track that.