ExpressionNode left = toExpression(between.getLeftOperand(), projects);
ValueNodeList rightOperandList = between.getRightOperandList();
ExpressionNode right1 = toExpression(rightOperandList.get(0), projects);
ExpressionNode right2 = toExpression(rightOperandList.get(1), projects);
DataTypeDescriptor sqlType = between.getType();
TInstance type = typesTranslator.typeForSQLType(sqlType);
conditions.add(new ComparisonCondition(Comparison.GE, left, right1, sqlType, null, type));
conditions.add(new ComparisonCondition(Comparison.LE, left, right2, sqlType, null, type));
}