gistfile1.sql

=> \d test;
     Table "public.test"
 Column |  Type   | Modifiers 
--------+---------+-----------
 id     | integer | 
 value  | integer | 

=> select * from test;
 id | value 
----+-------
  1 |     1
  2 |     3
  3 |    10
(3 rows)

gistfile2.clj

> (require '[honeysql.core :as sql.eng])
nil
> (require '[honeysql.helpers :as sql])
nil
> (defn test-query [conn]
    (let [query (-> (apply sql/select [[(sql.eng/call :max :value) "value"]])
                  (sql/from :test)
                  sql.eng/build
                  (sql.eng/format :quoting :ansi))]
      ;; Where do I put .setFetchSize here?
      (->> query
        (jdbc/query conn)
        first
        :value)))
#'/test-query
> (test-query c)
10