import { PgDatabase, PgQueryResultHKT, PgTransaction } from 'drizzle-orm/pg-core';
import { ExtractTablesWithRelations } from 'drizzle-orm/relations';

type AnyPgDatabase = PgDatabase<PgQueryResultHKT, Record<string, unknown>>;
/**
 * A driver-agnostic Drizzle PostgreSQL transaction handle.
 *
 * Unlike {@link AnyPgDatabase}, this type cannot be satisfied by a root
 * database. It is the native handle exposed to adapter-aware stores and
 * accepted when adopting a caller-owned PostgreSQL transaction.
 */
type AnyPgTransaction = PgTransaction<PgQueryResultHKT, Record<string, unknown>, ExtractTablesWithRelations<Record<string, unknown>>>;

export type { AnyPgDatabase as A, AnyPgTransaction as a };