import { TQueryValue, TSdOrmDataType } from "../../types";
import { QueryUnit } from "../queryable/QueryUnit";
import { DateOnly, DateTime, Time, Type, WrappedType } from "@simplysm/sd-core-common";
import { Queryable } from "../queryable/Queryable";
import { CaseWhenQueryHelper } from "../case/CaseWhenQueryHelper";
import { CaseQueryHelper } from "../case/CaseQueryHelper";
import { TDbContextOption } from "../../DbContext";
import { TEntityValue, TEntityValueOrQueryableOrArray } from "../queryable/types";
import { ISelectQueryDef, TDbDateSeparator, TQueryBuilderValue } from "./types";
export declare class QueryHelper {
    private readonly _dialect;
    constructor(_dialect: TDbContextOption["dialect"]);
    equal<T extends TQueryValue>(source: TEntityValue<T>, target: TEntityValue<T | undefined>): TQueryBuilderValue;
    notEqual<T extends TQueryValue>(source: TEntityValue<T>, target: TEntityValue<T | undefined>): TQueryBuilderValue[];
    isNull<T extends TQueryValue>(source: TEntityValue<T>): TQueryBuilderValue[];
    isNotNull<T extends TQueryValue>(source: TEntityValue<T>): TQueryBuilderValue[];
    isFalse<T extends TQueryValue>(source: TEntityValue<T>): TQueryBuilderValue[];
    isTrue<T extends TQueryValue>(source: TEntityValue<T>): TQueryBuilderValue[];
    lessThen<T extends string | String | number | Number | DateOnly | DateTime | Time>(source: TEntityValue<T | undefined>, target: TEntityValue<T | undefined>): TQueryBuilderValue[];
    lessThenOrEqual<T extends string | String | number | Number | DateOnly | DateTime | Time>(source: TEntityValue<T | undefined>, target: TEntityValue<T | undefined>): TQueryBuilderValue[];
    greaterThen<T extends string | String | number | Number | DateOnly | DateTime | Time>(source: TEntityValue<T | undefined>, target: TEntityValue<T | undefined>): TQueryBuilderValue[];
    greaterThenOrEqual<T extends string | String | number | Number | DateOnly | DateTime | Time>(source: TEntityValue<T | undefined>, target: TEntityValue<T | undefined>): TQueryBuilderValue[];
    between<T extends string | String | number | Number | DateOnly | DateTime | Time>(source: TEntityValue<T | undefined>, from: TEntityValue<T | undefined>, to: TEntityValue<T | undefined>): TQueryBuilderValue[];
    includes(source: TEntityValue<string | undefined>, target: TEntityValue<string | undefined>): TQueryBuilderValue[];
    notIncludes(source: TEntityValue<string | undefined>, target: TEntityValue<string | undefined>): TQueryBuilderValue[];
    like(source: TEntityValue<string | undefined>, target: TEntityValue<string | undefined>): TQueryBuilderValue[];
    notLike(source: TEntityValue<string | undefined>, target: TEntityValue<string | undefined>): TQueryBuilderValue[];
    regexp(source: TEntityValue<string | undefined>, target: TEntityValue<string | undefined>): TQueryBuilderValue[];
    notRegexp(source: TEntityValue<string | undefined>, target: TEntityValue<string | undefined>): TQueryBuilderValue[];
    startsWith(source: TEntityValue<string | undefined>, target: TEntityValue<string | undefined>): TQueryBuilderValue[];
    notStartsWith(source: TEntityValue<string | undefined>, target: TEntityValue<string | undefined>): TQueryBuilderValue[];
    endsWith(source: TEntityValue<string | undefined>, target: TEntityValue<string | undefined>): TQueryBuilderValue[];
    notEndsWith(source: TEntityValue<string | undefined>, target: TEntityValue<string | undefined>): TQueryBuilderValue[];
    in<P extends TQueryValue>(src: TEntityValue<P>, target: TEntityValue<P | undefined>[]): TQueryBuilderValue[];
    notIn<P extends TQueryValue>(src: TEntityValue<P>, target: TEntityValue<P | undefined>[]): TQueryBuilderValue[];
    and(args: TEntityValueOrQueryableOrArray<any, any>[]): TQueryBuilderValue[];
    or(args: TEntityValueOrQueryableOrArray<any, any>[]): TQueryBuilderValue[];
    query<T extends TQueryValue>(type: Type<WrappedType<T>>, texts: (string | QueryUnit<any>)[]): QueryUnit<T>;
    val<T extends TQueryValue>(value: TEntityValue<T>, type?: Type<WrappedType<NonNullable<T>>>): QueryUnit<T>;
    is(where: TQueryBuilderValue): QueryUnit<boolean>;
    dateDiff<T extends DateTime | DateOnly | Time>(separator: TDbDateSeparator, from: TEntityValue<T | 0>, to: TEntityValue<T | 0>): QueryUnit<number>;
    dateAdd<T extends DateTime | DateOnly | Time | undefined>(separator: TDbDateSeparator, from: TEntityValue<T>, value: TEntityValue<number>): QueryUnit<T>;
    /**
     *
     * @param value
     * @param code https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16
     */
    dateToString<T extends DateTime | DateOnly | Time>(value: TEntityValue<T | 0>, code: number): QueryUnit<string>;
    year<T extends DateTime | DateOnly>(value: TEntityValue<T>): QueryUnit<number>;
    month<T extends DateTime | DateOnly>(value: TEntityValue<T>): QueryUnit<number>;
    day<T extends DateTime | DateOnly | undefined>(value: TEntityValue<T>): QueryUnit<number>;
    isoWeek<T extends DateOnly | undefined>(value: TEntityValue<T>): QueryUnit<number>;
    isoWeekStartDate<T extends DateOnly | undefined>(value: TEntityValue<T>): QueryUnit<T>;
    isoYearMonth<T extends DateOnly | undefined>(value: TEntityValue<T>): QueryUnit<T>;
    ifNull<S extends TQueryValue, T extends TQueryValue>(source: TEntityValue<S>, ...targets: TEntityValue<T>[]): QueryUnit<S extends undefined ? T : S>;
    case<T extends TQueryValue>(predicate: TEntityValue<boolean | Boolean> | TQueryBuilderValue, then: TEntityValue<T>): CaseQueryHelper<T>;
    caseWhen<T extends TQueryValue>(arg: TEntityValue<TQueryValue>): CaseWhenQueryHelper<T>;
    greatest<T extends undefined | number | Number | DateOnly | DateTime | Time | string | String>(...args: TEntityValue<T>[]): QueryUnit<T>;
    /**
     * @deprecated
     * MSSQL 2022이하는 GREATEST 사용이 불가하여 만든 함수
     */
    greater<T extends number | Number | DateOnly | DateTime | Time>(source: TEntityValue<T>, target: TEntityValue<T>): QueryUnit<T>;
    dataLength<T extends TQueryValue>(arg: TEntityValue<T>): QueryUnit<number>;
    stringLength(arg: TEntityValue<String | string>): QueryUnit<number>;
    cast<T extends TQueryValue>(src: TEntityValue<TQueryValue>, targetType: Type<WrappedType<T>>): QueryUnit<T>;
    left(src: TEntityValue<string | String | undefined>, num: TEntityValue<number | Number>): QueryUnit<string>;
    padStart(src: TEntityValue<string | String | undefined>, length: number, fillString: string): QueryUnit<string>;
    right(src: TEntityValue<string | String | undefined>, num: TEntityValue<number | Number>): QueryUnit<string>;
    trim(src: TEntityValue<string | String | undefined>): QueryUnit<string>;
    replace(src: TEntityValue<string | String | undefined>, from: TEntityValue<String | string>, to: TEntityValue<String | string>): QueryUnit<string>;
    toUpperCase(src: TEntityValue<string | String | undefined>): QueryUnit<string>;
    toLowerCase(src: TEntityValue<string | String | undefined>): QueryUnit<string>;
    abs(src: TEntityValue<number | Number | undefined>): QueryUnit<number>;
    concat(...args: TEntityValue<string | String | number | Number | undefined>[]): QueryUnit<string>;
    rowIndex(orderBy: [TEntityValue<TQueryValue>, "asc" | "desc"][], groupBy?: TEntityValue<TQueryValue>[]): QueryUnit<number>;
    count<T extends TQueryValue>(arg?: TEntityValue<T>): QueryUnit<number>;
    sum<T extends number | Number | undefined>(arg: TEntityValue<T>): QueryUnit<T extends undefined ? undefined | number : number>;
    avg<T extends number | Number>(arg: TEntityValue<T | undefined>): QueryUnit<number | undefined>;
    round<T extends number | Number>(arg: TEntityValue<T>, len: number): QueryUnit<number>;
    ceil<T extends number | Number>(arg: TEntityValue<T>): QueryUnit<number>;
    floor<T extends number | Number>(arg: TEntityValue<T>): QueryUnit<number>;
    max<T extends undefined | number | Number | string | String | DateOnly | DateTime | Time | boolean>(unit: TEntityValue<T>): QueryUnit<T>;
    min<T extends undefined | number | Number | string | String | DateOnly | DateTime | Time | boolean>(unit: TEntityValue<T>): QueryUnit<T>;
    exists<T extends TQueryValue>(arg: TEntityValue<T>): QueryUnit<boolean>;
    notExists<T extends TQueryValue>(arg: TEntityValue<T>): QueryUnit<boolean>;
    getQueryValue(value: TEntityValue<any>): string;
    getQueryValue(value: Queryable<any, any>): ISelectQueryDef;
    getBulkInsertQueryValue(value: TEntityValue<any>): any;
    private _getBulkInsertQueryValueArray;
    private _getQueryValueArray;
    type(type: Type<TQueryValue> | TSdOrmDataType | string | undefined): string;
    mysqlConvertType(type: Type<TQueryValue>): string;
}