@SuppressWarnings("rawtypes")
    @Override
    public boolean check(SourceData sourceData, int rowIndex, Context context) {
        Comparable leftValue = (Comparable) this.left.parse(sourceData, rowIndex, context);
        Comparable startValue = (Comparable) this.start.parse(sourceData, rowIndex, context);
        Comparable endValue = (Comparable) this.end.parse(sourceData, rowIndex, context);

        boolean result = OperatorTools.compareValue(leftValue, startValue) >= 0 &&
                OperatorTools.compareValue(leftValue, endValue) <= 0;

        return this.isNot != result;
    }
BetweenAndOperator

This class implements the ExpressionOperator interface to handle the SQL BETWEEN AND operator.
It checks if a left value is between start and end value.
inlong-sdk/transform-sdk/src/main/java/org/apache/inlong/sdk/transform/process/operator/BetweenAndOperator.java