JoinDefinition class

Representation of a JOIN clause applied during query compilation.

This class encapsulates all the necessary information to construct a SQL JOIN clause, including the type of join, the target table or subquery, an optional alias, and the conditions for the join.

Example:

final join = JoinDefinition(
  type: JoinType.inner,
  target: JoinTarget.table('profiles'),
  conditions: [
    JoinCondition.column(
      left: 'users.id',
      operator: '=',
      right: 'profiles.user_id',
    ),
  ],
);