export interface Connection {
  readonly execute: (sql: string, params: ReadonlyArray<Primitive>) => Effect<ReadonlyArray<any>, SqlError>

  /**
   * Execute the specified SQL query and return the raw results directly from
   * underlying SQL client.
   */
  readonly executeRaw: (sql: string, params: ReadonlyArray<Primitive>) => Effect<unknown, SqlError>

  readonly executeStream: (sql: string, params: ReadonlyArray<Primitive>) => Stream<any, SqlError>

  readonly executeWithoutTransform: (
    sql: string,
    params: ReadonlyArray<Primitive>
  ) => Effect<ReadonlyArray<any>, SqlError>

  readonly executeValues: (
    sql: string,
    params: ReadonlyArray<Primitive>
  ) => Effect<ReadonlyArray<ReadonlyArray<Primitive>>, SqlError>

  readonly executeUnprepared: (
    sql: string,
    params?: ReadonlyArray<Primitive> | undefined
  ) => Effect<ReadonlyArray<any>, SqlError>
}

export type Row = { readonly [column: string]: Primitive }

export declare const Connection: any

export type Acquirer = Effect<Connection, SqlError, Scope>