Add JSONB support to yesql and automatically unserialize json/jsonb columns with cheshire

pg-jsonb.clj

(ns foo.bar
(:require [cheshire.core :as json]
          [clojure.java.jdbc :as jdbc])
(:import [org.postgresql.util PGobject]))


(defn extend-db-driver []

 (extend-type org.postgresql.util.PGobject
   jdbc/IResultSetReadColumn
   (result-set-read-column [val rsmeta idx]
                           (let [colType (.getColumnTypeName rsmeta idx)]
                             (if (or (= colType "json")
                                     (= colType "jsonb"))
                               (json/parse-string (.getValue val) true) val)))))