import { Effect } from "effect";
import { type OperationError } from "../errors/index.js";
import { Sqlite } from "./sqlite.js";
export interface ColumnDef {
    type: "TEXT" | "INTEGER" | "REAL" | "BLOB";
    primaryKey?: boolean;
    notNull?: boolean;
}
export interface IndexDef<T> {
    columns: (keyof T)[];
    unique?: boolean;
}
export interface TableOptions<T extends object> {
    name: string;
    columns: Record<keyof T & string, ColumnDef>;
    indexes?: IndexDef<T>[];
}
/**
 * A typed real SQL table (columns, indexes) on the shared `Sqlite` connection.
 * `Table.make` creates the schema idempotently; every operation afterwards is
 * an `Effect` bound to that connection.
 */
export declare class Table<T extends object> {
    private readonly db;
    private readonly options;
    private readonly columnNames;
    private readonly primaryKeys;
    private constructor();
    /** Ensures the table and its indexes exist, then resolves the typed handle. */
    static make<T extends object>(options: TableOptions<T>): Effect.Effect<Table<T>, OperationError, Sqlite>;
    get name(): string;
    private createTable;
    private createIndexes;
    /** INSERT OR IGNORE. Resolves true if a row was inserted. */
    insert(row: T): Effect.Effect<boolean, OperationError>;
    /** INSERT OR REPLACE. */
    upsert(row: T): Effect.Effect<void, OperationError>;
    /** `SELECT * ... WHERE <where>` with positional params. */
    query(where: string, params?: unknown[]): Effect.Effect<T[], OperationError>;
    all(): Effect.Effect<T[], OperationError>;
    /** Deletes every row. */
    clear(): Effect.Effect<void, OperationError>;
}