Method execute

repos/effect/packages/sql/pg/src/PgClient.ts:669–677

(
    sql: string,
    params: ReadonlyArray<unknown>,
    transformRows: (<A extends object>(row: ReadonlyArray<A>) => ReadonlyArray<A>) | undefined
  )

    return this.runWithClient<ReadonlyArray<any>>((client, resume) => {
      client.query(query, params as any, (err, result) => {
        if (err) {
          resume(
            Effect.fail(new SqlError({ reason: classifyError(err, "Failed to execute statement", "execute") }))
          )
        } else {
          // Multi-statement queries return an array of results
          resume(Effect.succeed(
            Array.isArray(result)
              ? result.map((r) => r.rows ?? [])
              : result.rows ?? []
          ))
        }