Delicious SQL for Clojure.
Korma is just getting started, use at your own peril
(use 'korma.db)
(defdb db (postgres {:db "mydb"
:user "user"
:password "dbpass"}))
(use 'korma.core)
(defentity user)
(select user)
;; executes: SELECT * FROM user
(select user
(fields :username :id))
;; executes: SELECT username, id FROM user
(select user
(where {:username "chris"}))
;; executes: SELECT * FROM user WHERE username = 'chris'
(select user
(where {:active true})
(order :created)
(limit 5)
(offset 3))
;; executes: SELECT * FROM user WHERE active = true ORDER BY created DESC LIMIT 5 OFFSET 3
Copyright (C) 2011 Chris Granger
Distributed under the Eclipse Public License, the same as Clojure.