leftJoin<OR> method

SelectFromBuilder<S, R, (R0, R1, R2, OR?)> leftJoin<OR>(
  1. Schema<OR> table, {
  2. required Filter on,
})

Add a left join clause of the builder.

Implementation

SelectFromBuilder<S, R, (R0, R1, R2, OR?)> leftJoin<OR>(
  Schema<OR> table, {
  required Filter on,
}) {
  final result = config.selecting! as SelectableResult;
  final o = table.$;

  return SelectFromBuilder(
    executor,
    config: config.copyWith({
      #selecting: SelectableResult<(R0, R1, R2, OR)>([...result.selected, o]),
      #joins: [
        ...config.joins,
        LeftJoin<Schema<OR>, OR>(o, on: on),
      ],
    }),
  );
}