feat: Add support for BuildRight

[andygrove]

What is the problem the feature request solves?

We are unable to run a number of TPC-H natively due to the error BuildRight is not supported. The queries affected include q2, q9, q10, q11, and q16.

See code in QueryPlanSerde.

if (join.buildSide == BuildRight) {
  // DataFusion HashJoin assumes build side is always left.
  // TODO: support BuildRight
  withInfo(join, "BuildRight is not supported")
  return None
}

Describe the potential solution

No response

Additional context

No response

[andygrove]

Related issue in DataFusion: apache/datafusion#9603

[viirya]

I will work on this at DataFusion.