import { type Knex } from "knex";
import { type TableSpec } from "../entity/entity-manager";
import { type ClearStatements } from "./puri-subset.types";
import { type AvailableColumns, type ColumnKeys, type ComparisonOperator, type Expand, type ExtractColumnType, type FulltextColumns, type FuzzyOperator, type InsertData, type InsertResult, type LeftJoinedMarker, type LeftJoinMarkerFor, type NumericColumns, type OnConflictAction, type ParseSelectObject, type ResultAvailableColumns, type SelectAllResult, type SelectObject, type SingleTableValue, type SqlExpression, type TsHighlightOptions, type TsQueryConfig, type TsQueryOptions, type TsRankOptions, type VectorColumns, type WhereCondition, type WhereOperator } from "./puri.types";
export declare class Puri<TSchema, TTables extends Record<string, any>, TResult> {
    knex: Knex;
    private knexQuery;
    private tableSpec;
    constructor(knex: Knex, tableName: string);
    constructor(knex: Knex, tableSource: Record<string, string | Puri<TSchema, any, any>>);
    safeGetTableSpec(tableName: string): TableSpec | null;
    static count(column?: string): SqlExpression<"number">;
    static sum(column: string): SqlExpression<"number">;
    static avg(column: string): SqlExpression<"number">;
    static max(column: string): SqlExpression<"number">;
    static min(column: string): SqlExpression<"number">;
    static concat(...args: string[]): SqlExpression<"string">;
    static upper(column: string): SqlExpression<"string">;
    static lower(column: string): SqlExpression<"string">;
    static wordSimilarity(column: string | SqlExpression<"string">, query: string): SqlExpression<"number">;
    static similarity(column: string | SqlExpression<"string">, query: string): SqlExpression<"number">;
    static strictWordSimilarity(column: string | SqlExpression<"string">, query: string): SqlExpression<"number">;
    static rawString(sql: string, params?: Knex.RawBinding[]): SqlExpression<"string">;
    static rawStringArray(sql: string, params?: Knex.RawBinding[]): SqlExpression<"string[]">;
    static rawNumber(sql: string, params?: Knex.RawBinding[]): SqlExpression<"number">;
    static rawBoolean(sql: string, params?: Knex.RawBinding[]): SqlExpression<"boolean">;
    static rawDate(sql: string, params?: Knex.RawBinding[]): SqlExpression<"date">;
    /**
     * FTS 검색어 하이라이팅
     *
     * @example
     * .select({
     *   title: Puri.highlight("posts.title", search),
     *   content: Puri.highlight("posts.content", search, {
     *     startSel: "<mark>",
     *     stopSel: "</mark>",
     *     maxFragments: 3,
     *   }),
     * })
     */
    static tsHighlight(column: string, query: string, _options?: TsHighlightOptions): SqlExpression<"string">;
    static tsRank(column: string | SqlExpression<"tsvector">, query: string, options?: TsRankOptions): SqlExpression<"number">;
    static tsRankCd(column: string | SqlExpression<"tsvector">, query: string, options?: TsRankOptions): SqlExpression<"number">;
    static toTsVector(column: string, config?: string): SqlExpression<"tsvector">;
    static _tsRank(type: "ts_rank" | "ts_rank_cd", column: string | SqlExpression<"tsvector">, query: string, options?: TsRankOptions): SqlExpression<"number">;
    /**
     * PGroonga FullText 인덱스 검색 점수
     *
     * @example
     * .select({
     *   score: Puri.score(),
     * })
     */
    static score(): SqlExpression<"number">;
    /**
     * PGroonga FullText 인덱스 검색 하이라이팅
     *
     * @example
     * .select({
     *   title: Puri.highlight("posts.title", search),
     * })
     */
    static highlight(column: string, query: string | string[]): SqlExpression<"string">;
    static highlight(columns: string[], query: string | string[]): SqlExpression<"string[]">;
    select<TSelect extends SelectObject<TTables>>(selectObj: TSelect): Puri<TSchema, TTables, ParseSelectObject<TTables, TSelect>>;
    /**
     * 중첩 객체를 flat 객체로 변환
     * 예: { parent: { id: "parent.id", name: "parent.name" } }
     *   → { parent__id: "parent.id", parent__name: "parent.name" }
     */
    private flattenSelect;
    appendSelect<TSelect extends SelectObject<TTables>>(selectObj: TSelect): Puri<TSchema, TTables, TResult & ParseSelectObject<TTables, TSelect>>;
    selectAll(): Puri<TSchema, TTables, SelectAllResult<TTables>>;
    distinct<TColumns extends AvailableColumns<TTables>>(...columns: TColumns[]): this;
    clear(statement: ClearStatements): this;
    clearJoin(alias: string): this;
    join<TJoinAlias extends string, TSubResult>(tableSpec: {
        [K in TJoinAlias]: Puri<TSchema, any, TSubResult>;
    }, left: AvailableColumns<TTables>, right: `${TJoinAlias}.${ColumnKeys<TSubResult>}`): Puri<TSchema, TTables & Record<TJoinAlias, TSubResult>, // 서브쿼리의 TResult
    TResult>;
    join<TJoinTable extends keyof TSchema, TJoinAlias extends string>(tableSpec: {
        [K in TJoinAlias]: TJoinTable;
    }, left: AvailableColumns<TTables>, right: `${TJoinAlias}.${ColumnKeys<TSchema[TJoinTable]>}`): Puri<TSchema, TTables & Record<TJoinAlias, TSchema[TJoinTable]>, // TTables 확장!
    TResult>;
    join<TJoinTable extends keyof TSchema>(tableName: TJoinTable, left: AvailableColumns<TTables>, right: `${TJoinTable & string}.${ColumnKeys<TSchema[TJoinTable]>}`): Puri<TSchema, TTables & Record<TJoinTable, TSchema[TJoinTable]>, // 테이블명이 키
    TResult>;
    join<TJoinAlias extends string, TSubResult>(tableSpec: {
        [K in TJoinAlias]: Puri<TSchema, any, TSubResult>;
    }, callback: (j: JoinClauseGroup<TTables, Record<TJoinAlias, TSubResult>>) => void): Puri<TSchema, TTables & Record<TJoinAlias, TSubResult>, TResult>;
    join<TJoinTable extends keyof TSchema, TJoinAlias extends string>(tableSpec: {
        [K in TJoinAlias]: TJoinTable;
    }, callback: (j: JoinClauseGroup<TTables, Record<TJoinAlias, TSchema[TJoinTable]>>) => void): Puri<TSchema, TTables & Record<TJoinAlias, TSchema[TJoinTable]>, TResult>;
    join<TJoinTable extends keyof TSchema>(tableName: TJoinTable, callback: (j: JoinClauseGroup<TTables, Record<TJoinTable, TSchema[TJoinTable]>>) => void): Puri<TSchema, TTables & Record<TJoinTable, TSchema[TJoinTable]>, TResult>;
    leftJoin<TJoinAlias extends string, TSubResult>(tableSpec: {
        [K in TJoinAlias]: Puri<TSchema, any, TSubResult>;
    }, left: AvailableColumns<TTables>, right: `${TJoinAlias}.${ColumnKeys<TSubResult>}`): Puri<TSchema, TTables & Record<TJoinAlias, TSubResult & LeftJoinedMarker>, TResult>;
    leftJoin<TJoinTable extends keyof TSchema, TJoinAlias extends string, TLeft extends AvailableColumns<TTables>>(tableSpec: {
        [K in TJoinAlias]: TJoinTable;
    }, left: TLeft, right: `${TJoinAlias}.${ColumnKeys<TSchema[TJoinTable]>}`): Puri<TSchema, TTables & Record<TJoinAlias, TSchema[TJoinTable] & LeftJoinMarkerFor<TTables, TLeft>>, TResult>;
    leftJoin<TJoinTable extends keyof TSchema, TLeft extends AvailableColumns<TTables>>(tableName: TJoinTable, left: TLeft, right: `${TJoinTable & string}.${ColumnKeys<TSchema[TJoinTable]>}`): Puri<TSchema, TTables & Record<TJoinTable, TSchema[TJoinTable] & LeftJoinMarkerFor<TTables, TLeft>>, TResult>;
    leftJoin<TJoinAlias extends string, TSubResult>(tableSpec: {
        [K in TJoinAlias]: Puri<TSchema, any, TSubResult>;
    }, callback: (j: JoinClauseGroup<TTables, Record<TJoinAlias, TSubResult>>) => void): Puri<TSchema, TTables & Record<TJoinAlias, TSubResult & LeftJoinedMarker>, TResult>;
    leftJoin<TJoinTable extends keyof TSchema, TJoinAlias extends string>(tableSpec: {
        [K in TJoinAlias]: TJoinTable;
    }, callback: (j: JoinClauseGroup<TTables, Record<TJoinAlias, TSchema[TJoinTable]>>) => void): Puri<TSchema, TTables & Record<TJoinAlias, TSchema[TJoinTable] & LeftJoinedMarker>, TResult>;
    leftJoin<TJoinTable extends keyof TSchema>(tableName: TJoinTable, callback: (j: JoinClauseGroup<TTables, Record<TJoinTable, TSchema[TJoinTable]>>) => void): Puri<TSchema, TTables & Record<TJoinTable, TSchema[TJoinTable] & LeftJoinedMarker>, TResult>;
    __commonJoin(joinType: "join" | "leftJoin", tableNameOrSpec: any, ...args: any[]): this;
    where(conditions: WhereCondition<TTables>): this;
    where<TColumn extends AvailableColumns<TTables>>(column: TColumn, value: ExtractColumnType<TTables, TColumn & string>): this;
    where<TColumn extends AvailableColumns<TTables>>(column: TColumn, operator: WhereOperator, value: ExtractColumnType<TTables, TColumn & string>): this;
    where<TColumn extends Knex.Raw>(column: TColumn, operator: WhereOperator, value: any): this;
    whereIn<TColumn extends AvailableColumns<TTables>>(column: TColumn, values: ExtractColumnType<TTables, TColumn & string>[]): Puri<TSchema, TTables, TResult>;
    whereNotIn<TColumn extends AvailableColumns<TTables>>(column: TColumn, values: ExtractColumnType<TTables, TColumn & string>[]): Puri<TSchema, TTables, TResult>;
    whereMatch<TColumn extends FulltextColumns<TTables>>(column: TColumn, value: string): this;
    /**
     * PGroonga FullText 인덱스 검색
     * - 사용할 PGroonga 인덱스와 동일한 컬럼 구성으로 검색해야 인덱스가 사용됩니다.
     *
     * 단일 컬럼 검색:
     * ```sql
     * WHERE name &@~ 'search'
     * ```
     *
     * 복합 컬럼 검색:
     * ```sql
     * WHERE ARRAY[name::text, description::text] &@~ 'search'
     * ```
     */
    whereSearch<TColumn extends AvailableColumns<TTables>>(column: TColumn | TColumn[], value: string, options?: {
        weights?: number[];
    }): this;
    whereTsSearch<TColumn extends AvailableColumns<TTables> | SqlExpression<"string">>(column: TColumn, value: string, options?: TsQueryOptions | TsQueryConfig): this;
    whereFuzzy<TColumn extends AvailableColumns<TTables> | SqlExpression<"string">>(column: TColumn, value: string, options?: {
        operator?: FuzzyOperator;
    }): this;
    whereRaw(sql: string, bindings?: readonly Knex.RawBinding[]): this;
    whereGroup(callback: (g: WhereGroup<TTables>) => void): this;
    orWhereGroup(callback: (g: WhereGroup<TTables>) => void): this;
    orderBy<TColumn extends ResultAvailableColumns<TTables, TResult>>(column: TColumn | SqlExpression<"number"> | SqlExpression<"string">, direction: "asc" | "desc"): this;
    /**
     * 벡터 유사도 검색 설정
     *
     * - SELECT에 similarity 컬럼 추가
     * - WHERE col IS NOT NULL 추가
     * - threshold가 있으면 WHERE 조건 추가
     * - 기존 ORDER BY를 clear하고 원시 연산자로 정렬 (HNSW 인덱스 최적화)
     *
     * @param column 벡터 컬럼 경로
     * @param embedding 쿼리 임베딩 벡터
     * @param options method, threshold, as 등 옵션
     *
     * @example
     * ```typescript
     * // cosine similarity (기본값)
     * qb.vectorSimilarity("columnName", queryVector, {
     *   method: "cosine",
     *   threshold: 0.5
     * });
     *
     * // L2 distance
     * qb.vectorSimilarity("columnName", queryVector, {
     *   method: "l2",
     *   threshold: 1.5  // 거리가 1.5 이하인 결과만
     * });
     *
     * // Inner product
     * qb.vectorSimilarity("columnName", queryVector, {
     *   method: "inner_product",
     *   threshold: 0.7
     * });
     * ```
     */
    vectorSimilarity(column: VectorColumns<TTables>, embedding: number[], options?: {
        method?: "cosine" | "l2" | "inner_product";
        threshold?: number;
        distinctOn?: AvailableColumns<TTables>;
    }): Puri<TSchema, TTables, TResult & {
        similarity: number;
    }>;
    limit(count: number): this;
    offset(count: number): this;
    groupBy<TColumns extends ResultAvailableColumns<TTables, TResult>>(...columns: TColumns[]): this;
    having(condition: string): this;
    having<TColumn extends ResultAvailableColumns<TTables, TResult>>(column: TColumn, operator: ComparisonOperator, value: any): this;
    then<TResult1 = Expand<TResult>[], TResult2 = never>(onfulfilled?: ((value: Expand<TResult>[]) => TResult1 | PromiseLike<TResult1>) | null, onrejected?: ((reason: any) => TResult2 | PromiseLike<TResult2>) | null): Promise<TResult1 | TResult2>;
    catch<TResult2 = never>(onrejected?: ((reason: any) => TResult2 | PromiseLike<TResult2>) | null): Promise<TResult | TResult2>;
    finally(onfinally?: (() => void) | null): Promise<TResult>;
    first(): ResolvedPuri<Expand<TResult>, never>;
    pluck<TColumn extends keyof TResult | ResultAvailableColumns<TTables, TResult>>(column: TColumn): ResolvedPuri<TColumn extends keyof TResult ? TResult[TColumn][] : ExtractColumnType<TTables, TColumn & string>[], never>;
    insert(data: InsertData<SingleTableValue<TTables>>): ResolvedPuri<InsertResult, SingleTableValue<TTables>>;
    insert(data: InsertData<SingleTableValue<TTables>>[]): ResolvedPuri<InsertResult, SingleTableValue<TTables>>;
    update(rawData: WhereCondition<TTables>): ResolvedPuri<number, SingleTableValue<TTables>>;
    /**
     * JSON 컬럼에 대해 stringify 처리를 수행하는 내부 메서드입니다.
     * object 또는 object 배열을 받고, JSON 컬럼이 있으면 직렬화하여 반환합니다.
     * 직접 값을 변경하므로 side effect가 있습니다.
     */
    private refineJsonColumns;
    increment<TColumn extends NumericColumns<TTables>>(column: TColumn, value: number): ResolvedPuri<number, SingleTableValue<TTables>>;
    decrement<TColumn extends NumericColumns<TTables>>(column: TColumn, value: number): ResolvedPuri<number, SingleTableValue<TTables>>;
    delete(): ResolvedPuri<number, SingleTableValue<TTables>>;
    toQuery(): string;
    debug(): this;
    clone(): Puri<TSchema, TTables, TResult>;
    formatSQL(unformatted: string): string;
    raw(sql: string): Knex.Raw;
    rawQuery(): Knex.QueryBuilder;
}
export declare class WhereGroup<TTables extends Record<string, any>> {
    private builder;
    constructor(builder: Knex.QueryBuilder);
    where(conditions: WhereCondition<TTables>): this;
    where<TColumn extends AvailableColumns<TTables>>(column: TColumn, value: ExtractColumnType<TTables, TColumn & string>): this;
    where<TColumn extends AvailableColumns<TTables>>(column: TColumn, operator: WhereOperator, value: ExtractColumnType<TTables, TColumn & string>): this;
    whereIn<TColumn extends AvailableColumns<TTables>>(column: TColumn, values: ExtractColumnType<TTables, TColumn & string>[]): this;
    whereNotIn<TColumn extends AvailableColumns<TTables>>(column: TColumn, values: ExtractColumnType<TTables, TColumn & string>[]): this;
    orWhere(conditions: WhereCondition<TTables>): this;
    orWhere<TColumn extends AvailableColumns<TTables>>(column: TColumn, value: ExtractColumnType<TTables, TColumn & string>): this;
    orWhere<TColumn extends AvailableColumns<TTables>>(column: TColumn, operator: WhereOperator, value: ExtractColumnType<TTables, TColumn & string>): this;
    orWhereIn<TColumn extends AvailableColumns<TTables>>(column: TColumn, values: ExtractColumnType<TTables, TColumn & string>[]): this;
    orWhereNotIn<TColumn extends AvailableColumns<TTables>>(column: TColumn, values: ExtractColumnType<TTables, TColumn & string>[]): this;
    whereMatch<TColumn extends FulltextColumns<TTables>>(column: TColumn, value: string): this;
    orWhereMatch<TColumn extends FulltextColumns<TTables>>(column: TColumn, value: string): this;
    whereSearch<TColumn extends AvailableColumns<TTables>>(column: TColumn | TColumn[], value: string, options?: {
        weights?: number[];
    }): this;
    orWhereSearch<TColumn extends AvailableColumns<TTables>>(column: TColumn | TColumn[], value: string, options?: {
        weights?: number[];
    }): this;
    whereTsSearch<TColumn extends AvailableColumns<TTables> | SqlExpression<"string">>(column: TColumn, value: string, options?: TsQueryOptions | TsQueryConfig): this;
    orWhereTsSearch<TColumn extends AvailableColumns<TTables> | SqlExpression<"string">>(column: TColumn, value: string, options?: TsQueryOptions | TsQueryConfig): this;
    whereFuzzy<TColumn extends AvailableColumns<TTables> | SqlExpression<"string">>(column: TColumn, value: string, options?: {
        operator?: FuzzyOperator;
    }): this;
    orWhereFuzzy<TColumn extends AvailableColumns<TTables> | SqlExpression<"string">>(column: TColumn, value: string, options?: {
        operator?: FuzzyOperator;
    }): this;
    whereGroup(callback: (g: WhereGroup<TTables>) => void): this;
    orWhereGroup(callback: (g: WhereGroup<TTables>) => void): this;
}
export declare class JoinClauseGroup<TLeft extends Record<string, any>, TRight extends Record<string, any>> {
    private callback;
    constructor(callback: Knex.JoinClause);
    on(left: AvailableColumns<TLeft>, right: AvailableColumns<TRight>): this;
    on(left: AvailableColumns<TRight>, right: AvailableColumns<TLeft>): this;
    on(left: AvailableColumns<TLeft>, right: ExtractColumnType<TLeft, AvailableColumns<TLeft> & string>): this;
    on(left: AvailableColumns<TRight>, right: ExtractColumnType<TRight, AvailableColumns<TRight> & string>): this;
    on(left: AvailableColumns<TLeft>, operator: ComparisonOperator, right: AvailableColumns<TRight>): this;
    on(left: AvailableColumns<TRight>, operator: ComparisonOperator, right: AvailableColumns<TLeft>): this;
    on(left: AvailableColumns<TLeft>, operator: ComparisonOperator, right: ExtractColumnType<TLeft, AvailableColumns<TLeft> & string>): this;
    on(left: AvailableColumns<TRight>, operator: ComparisonOperator, right: ExtractColumnType<TRight, AvailableColumns<TRight> & string>): this;
    on(callback: (nested: JoinClauseGroup<TLeft, TRight>) => void): this;
    on(callback: (nested: JoinClauseGroup<TRight, TLeft>) => void): this;
    orOn(left: AvailableColumns<TLeft>, right: AvailableColumns<TRight>): this;
    orOn(left: AvailableColumns<TRight>, right: AvailableColumns<TLeft>): this;
    orOn(left: AvailableColumns<TLeft>, right: ExtractColumnType<TLeft, AvailableColumns<TLeft> & string>): this;
    orOn(left: AvailableColumns<TRight>, right: ExtractColumnType<TRight, AvailableColumns<TRight> & string>): this;
    orOn(left: AvailableColumns<TLeft>, operator: ComparisonOperator, right: AvailableColumns<TRight>): this;
    orOn(left: AvailableColumns<TRight>, operator: ComparisonOperator, right: AvailableColumns<TLeft>): this;
    orOn(left: AvailableColumns<TLeft>, operator: ComparisonOperator, right: ExtractColumnType<TLeft, AvailableColumns<TLeft> & string>): this;
    orOn(left: AvailableColumns<TRight>, operator: ComparisonOperator, right: ExtractColumnType<TRight, AvailableColumns<TRight> & string>): this;
    orOn(callback: (nested: JoinClauseGroup<TLeft, TRight>) => void): this;
    orOn(callback: (nested: JoinClauseGroup<TRight, TLeft>) => void): this;
    onVal(column: AvailableColumns<TLeft>, value: any): this;
    onVal(column: AvailableColumns<TRight>, value: any): this;
    onVal(column: AvailableColumns<TLeft>, operator: ComparisonOperator, value: any): this;
    onVal(column: AvailableColumns<TRight>, operator: ComparisonOperator, value: any): this;
    andOnVal(column: AvailableColumns<TLeft>, value: any): this;
    andOnVal(column: AvailableColumns<TRight>, value: any): this;
    andOnVal(column: AvailableColumns<TLeft>, operator: ComparisonOperator, value: any): this;
    andOnVal(column: AvailableColumns<TRight>, operator: ComparisonOperator, value: any): this;
    orOnVal(column: AvailableColumns<TLeft>, value: any): this;
    orOnVal(column: AvailableColumns<TRight>, value: any): this;
    orOnVal(column: AvailableColumns<TLeft>, operator: ComparisonOperator, value: any): this;
    orOnVal(column: AvailableColumns<TRight>, operator: ComparisonOperator, value: any): this;
}
export declare class ResolvedPuri<TResolved, TReturning> implements Promise<TResolved> {
    knexQuery: Knex.QueryBuilder;
    private knex;
    constructor(knexQuery: Knex.QueryBuilder, knex: Knex);
    [Symbol.toStringTag]: string;
    toQuery(): string;
    debug(): this;
    then<TResult1 = TResolved, TResult2 = never>(onfulfilled?: ((value: TResolved) => TResult1 | PromiseLike<TResult1>) | null, onrejected?: ((reason: any) => TResult2 | PromiseLike<TResult2>) | null): Promise<TResult1 | TResult2>;
    catch<TResult2 = never>(onrejected?: ((reason: any) => TResult2 | PromiseLike<TResult2>) | null): Promise<TResolved | TResult2>;
    finally(onfinally?: (() => void) | null): Promise<TResolved>;
    onConflict<TTables extends Record<string, TReturning>>(columns: string | string[], action?: OnConflictAction<TTables>): this;
    returning(column: "*"): ResolvedPuri<TReturning[], never>;
    returning<TColumn extends ColumnKeys<TReturning>>(column: TColumn): ResolvedPuri<Pick<TReturning, TColumn>[], never>;
    returning<TColumn extends ColumnKeys<TReturning>>(columns: TColumn[]): ResolvedPuri<Pick<TReturning, TColumn>[], never>;
}
//# sourceMappingURL=puri.d.ts.map