• Home
• com.easy-query
• sql-api4j
• 2.3.1
• source code
• SQLAggregatable9.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.easy.query.api4j.select.extension.queryable9.SQLAggregatable9 Maven / Gradle / Ivy

package com.easy.query.api4j.select.extension.queryable9;

import com.easy.query.api4j.sql.SQLColumnResultSelector;
import com.easy.query.api4j.sql.impl.SQLColumnResultSelectorImpl;
import com.easy.query.core.common.tuple.Tuple9;
import com.easy.query.core.expression.lambda.SQLExpression1;
import com.easy.query.core.expression.lambda.SQLExpression9;

import java.math.BigDecimal;

/**
 * create time 2023/8/17 17:02
 * 文件说明
 *
 * @author xuejiaming
 */
public interface SQLAggregatable9 extends ClientQueryable9Available {

    /**
     * 防止溢出
     *
     * @param columnSelectorExpression
     * @param 
     * @return
     */
    default  BigDecimal sumBigDecimalOrNull(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression) {
        return getClientQueryable9().sumBigDecimalOrNull((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        });
    }


    default  BigDecimal sumBigDecimalOrDefault(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression, BigDecimal def) {
        return getClientQueryable9().sumBigDecimalOrDefault((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        }, def);
    }

    default  TMember sumOrNull(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression) {
        return getClientQueryable9().sumOrNull((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        });
    }

    default  TMember sumOrDefault(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression, TMember def) {
        return getClientQueryable9().sumOrDefault((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        }, def);
    }

    default  TMember maxOrNull(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression) {
        return getClientQueryable9().maxOrNull((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        });
    }

    default  TMember maxOrDefault(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression, TMember def) {
        return getClientQueryable9().maxOrDefault((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        }, def);
    }

    default  TMember minOrNull(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression) {
        return getClientQueryable9().minOrNull((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        });
    }

    default  TMember minOrDefault(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression, TMember def) {
        return getClientQueryable9().minOrDefault((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        }, def);
    }

    default  Double avgOrNull(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression) {
        return getClientQueryable9().avgOrNull((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        });
    }

    default  BigDecimal avgBigDecimalOrNull(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression) {
        return getClientQueryable9().avgBigDecimalOrNull((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        });
    }

    default  Float avgFloatOrNull(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression) {
        return getClientQueryable9().avgFloatOrNull((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        });
    }

    default  Double avgOrDefault(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression, Double def) {
        return getClientQueryable9().avgOrDefault((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        }, def);
    }

    default  BigDecimal avgBigDecimalOrDefault(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression, BigDecimal def) {
        return getClientQueryable9().avgBigDecimalOrDefault((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        }, def);
    }

    default  Float avgFloatOrDefault(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression, Float def) {
        return getClientQueryable9().avgFloatOrDefault((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        }, def);
    }

    default  TResult avgOrDefault(SQLExpression9, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector> columnSelectorExpression, TResult def, Class resultClass) {
        return getClientQueryable9().avgOrDefault((selector1, selector2, selector3, selector4, selector5, selector6, selector7, selector8, selector9) -> {
            columnSelectorExpression.apply(new SQLColumnResultSelectorImpl<>(selector1), new SQLColumnResultSelectorImpl<>(selector2), new SQLColumnResultSelectorImpl<>(selector3), new SQLColumnResultSelectorImpl<>(selector4), new SQLColumnResultSelectorImpl<>(selector5), new SQLColumnResultSelectorImpl<>(selector6), new SQLColumnResultSelectorImpl<>(selector7), new SQLColumnResultSelectorImpl<>(selector8), new SQLColumnResultSelectorImpl<>(selector9));
        }, def, resultClass);
    }




    /**
     * 防止溢出
     *
     * @param columnSelectorExpression
     * @param 
     * @return
     */
    default  BigDecimal sumBigDecimalOrNullMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression) {
        return getClientQueryable9().sumBigDecimalOrNullMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        });
    }


    default  BigDecimal sumBigDecimalOrDefaultMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression, BigDecimal def) {
        return getClientQueryable9().sumBigDecimalOrDefaultMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        }, def);
    }

    default  TMember sumOrNullMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression) {
        return getClientQueryable9().sumOrNullMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        });
    }

    default  TMember sumOrDefaultMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression, TMember def) {
        return getClientQueryable9().sumOrDefaultMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        }, def);
    }

    default  TMember maxOrNullMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression) {
        return getClientQueryable9().maxOrNullMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        });
    }

    default  TMember maxOrDefaultMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression, TMember def) {
        return getClientQueryable9().maxOrDefaultMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        }, def);
    }

    default  TMember minOrNullMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression) {
        return getClientQueryable9().minOrNullMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        });
    }

    default  TMember minOrDefaultMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression, TMember def) {
        return getClientQueryable9().minOrDefaultMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        }, def);
    }

    default  Double avgOrNullMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression) {
        return getClientQueryable9().avgOrNullMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        });
    }

    default  BigDecimal avgBigDecimalOrNullMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression) {
        return getClientQueryable9().avgBigDecimalOrNullMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        });
    }

    default  Float avgFloatOrNullMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression) {
        return getClientQueryable9().avgFloatOrNullMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        });
    }

    default  Double avgOrDefaultMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression, Double def) {
        return getClientQueryable9().avgOrDefaultMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        }, def);
    }

    default  BigDecimal avgBigDecimalOrDefaultMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression, BigDecimal def) {
        return getClientQueryable9().avgBigDecimalOrDefaultMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        }, def);
    }

    default  Float avgFloatOrDefaultMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression, Float def) {
        return getClientQueryable9().avgFloatOrDefaultMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        }, def);
    }

    default  TResult avgOrDefaultMerge(SQLExpression1, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector, SQLColumnResultSelector>> columnSelectorExpression, TResult def, Class resultClass) {
        return getClientQueryable9().avgOrDefaultMerge((tuple9) -> {
            columnSelectorExpression.apply(new Tuple9<>(new SQLColumnResultSelectorImpl<>(tuple9.t()), new SQLColumnResultSelectorImpl<>(tuple9.t1()), new SQLColumnResultSelectorImpl<>(tuple9.t2()), new SQLColumnResultSelectorImpl<>(tuple9.t3()), new SQLColumnResultSelectorImpl<>(tuple9.t4()), new SQLColumnResultSelectorImpl<>(tuple9.t5()), new SQLColumnResultSelectorImpl<>(tuple9.t6()), new SQLColumnResultSelectorImpl<>(tuple9.t7()),new SQLColumnResultSelectorImpl<>(tuple9.t8())));
        }, def, resultClass);
    }
}