import DateTime from "@web-atoms/date-time/dist/DateTime";
export interface ISql {
    in<T>(a: T, array: T[]): boolean;
    coll: {
        sum(a: number[]): number;
        count(a: any[]): number;
        avg(a: number[]): number;
    };
    cast: {
        asNumber(a: any): number;
        asInteger(a: any): number;
        asBigInt(a: any): number;
        asText(a: any): string;
        asDate(a: any): Date;
        asDateTime(a: any): Date;
        asDecimal(a: any): number;
    };
    text: {
        concat(...fragments: string[]): string;
        concatWS(separator: string, ...fragments: string[]): string;
        difference(left: string, right: string): number;
        includes(text: string, test: string): boolean;
        like(text: string, test: string): boolean;
        likeAny(text: string, test: string[]): boolean;
        iLike(text: string, test: string): boolean;
        iLikeAny(text: string, test: string[]): boolean;
        left(text: string, length: number): string;
        right(text: string, length: number): string;
        startsWith(text: string, test: string): boolean;
        endsWith(text: string, test: string): boolean;
        indexOf(text: string, test: string): number;
        normalize(text: string, kind?: string): string;
        collate(text: string, collation: string): string;
        lower(text: string): string;
        upper(text: string): string;
        trim(text: string): string;
        reverse(text: string): string;
        substring(text: string, start: number, length?: number): string;
    };
    date: {
        now(): DateTime;
        yearOf(d: Date): number;
        monthOf(d: Date): number;
        dayOf(d: Date): number;
        minuteOf(d: Date): number;
        hourOf(d: Date): number;
        secondOf(d: Date): number;
        addYears(d: Date, n: number): Date;
        addMonths(d: Date, n: number): Date;
        addDays(d: Date, n: number): Date;
        addHours(d: Date, n: number): Date;
        addMinutes(d: Date, n: number): Date;
        addSeconds(d: Date, n: number): Date;
    };
}
export declare const Sql: ISql;
//# sourceMappingURL=Sql.d.ts.map