import type { EntityLoaderOrderByClause, EntityLoaderQuerySelectionModifiers } from './AuthorizationResultBasedKnexEntityLoader.ts';
import type { NullsOrdering } from './BasePostgresEntityDatabaseAdapter.ts';
import { OrderByOrdering } from './BasePostgresEntityDatabaseAdapter.ts';
import type { SQLFragment } from './SQLOperator.ts';
/**
 * Base SQL query builder that provides common functionality for building SQL queries.
 */
export declare abstract class BaseSQLQueryBuilder<TFields extends Record<string, any>, TSelectedFields extends keyof TFields, TResultType> {
    private readonly sqlFragment;
    private readonly modifiers;
    private executed;
    constructor(sqlFragment: SQLFragment<Pick<TFields, TSelectedFields>>, modifiers: {
        limit?: number;
        offset?: number;
        orderBy?: readonly EntityLoaderOrderByClause<TFields, TSelectedFields>[];
    });
    /**
     * Limit the number of results
     */
    limit(n: number): this;
    /**
     * Skip a number of results
     */
    offset(n: number): this;
    /**
     * Order by a field. Can be called multiple times to add multiple order bys.
     */
    orderBy(fieldName: TSelectedFields, order?: OrderByOrdering, nulls?: NullsOrdering): this;
    /**
     * Order by a SQL fragment expression.
     * Provides type-safe, parameterized ORDER BY clauses
     *
     * @example
     * ```ts
     * query.orderByFragment(
     *   sql`(data->>'createdAt')::timestamp`,
     *   OrderByOrdering.DESCENDING,
     * );
     * // Generates ORDER BY clause that orders by the createdAt field in the JSONB data column, cast to a timestamp, in descending order.
     * // Note that the SQL fragment is parameterized, so it is safe from SQL injection.
     * // The generated SQL would look like: ORDER BY (data->>'createdAt')::timestamp DESC
     * ```
     *
     * @param fragment - The SQL fragment to order by. Must not include the ASC/DESC keyword, as ordering direction is determined by the `order` parameter.
     * @param order - The ordering direction (ascending or descending). Defaults to ascending.
     */
    orderBySQL(fragment: SQLFragment<Pick<TFields, TSelectedFields>>, order?: OrderByOrdering, nulls?: NullsOrdering): this;
    /**
     * Get the current modifiers as QuerySelectionModifiersWithOrderByFragment<TFields>
     */
    protected getModifiers(): EntityLoaderQuerySelectionModifiers<TFields, TSelectedFields>;
    /**
     * Get the SQL fragment
     */
    protected getSQLFragment(): SQLFragment<Pick<TFields, TSelectedFields>>;
    /**
     * Execute the query and return results.
     * Implementation depends on the specific loader type.
     */
    executeAsync(): Promise<readonly TResultType[]>;
    protected abstract executeInternalAsync(): Promise<readonly TResultType[]>;
}