title: how to write this clojure.java.jdbc select where clause
body: <p>How can I implement <strong>select * from fruit where cost > 22 and cost &lt; 44</strong> w/ DSL way, by example below from <a href="https://github.com/clojure/java.jdbc" rel="nofollow">clojure/java.jdbc demo</a>:</p>
  
  <pre><code>(require '[clojure.java.jdbc :as j]
       '[clojure.java.jdbc.sql :as s])
  
  (def mysql-db {:subprotocol "mysql"
                 :subname "//127.0.0.1:3306/clojure_test"
                 :user "clojure_test"
                 :password "clojure_test"})
  
  (j/insert! mysql-db :fruit
    {:name "Apple" :appearance "rosy" :cost 24}
    {:name "Orange" :appearance "round" :cost 49})
  ;; ({:generated_key 1} {:generated_key 2})
  
  (j/query mysql-db
    (s/select * :fruit (s/where {:appearance "rosy"}))
    :row-fn :cost)
  ;; (24)
  </code></pre>
  
  <p>Thanks in advance.</p>