Function runValues

packages/sql-sqlite-node/src/SqliteClient.ts:152–173

(
        sql: string,
        params: ReadonlyArray<unknown>
      )

        )

      const runValues = (
        sql: string,
        params: ReadonlyArray<unknown>
      ) =>
        Effect.acquireUseRelease(
          prepareCache.get(sql),
          (statement) =>
            Effect.try({
              try: () => {
                if (statement.reader) {
                  statement.raw(true)
                  return statement.all(...params) as ReadonlyArray<
                    ReadonlyArray<unknown>
                  >
                }
                statement.run(...params)
                return []
              },
              catch: (cause) => new SqlError({ cause, message: "Failed to execute statement" })
            }),
          (statement) => Effect.sync(() => statement.reader && statement.raw(false))
        )

      return identity<SqliteConnection>({
        execute(sql, params, transformRows) {