Hey Sean, Most of the points in my reply to Roman also apply to `HoneySQL`. In particular this phrase in the README summarises a good deal of my criticism: "When using the vanilla helper functions, new clauses will replace old clauses". You have to go out of your way to get the composability that I desire.
`HoneySQL` seems like it would fit fairly well as compiler in the `clojure-sql` sense. A translation of the internal `clojure-sql` query into a `HoneySQL` format, then run it through the `HoneySQL` compiler. Is there a reason you don't use the database's table/column name quoting? It means that keywords like :first-name cannot be used as table names without a fair bit of trouble. (This was also an issue I had with most other SQL generation libraries I've seen, and something I made sure to fix in my `clojure-sql` compiler for PostgresSQL.) Thanks, Carlo On 6 July 2013 02:32, Sean Corfield <seancorfi...@gmail.com> wrote: > And there's HoneySQL: > > https://github.com/jkk/honeysql > > (that's the one java.jdbc will recommend going forward since I worked > with the author, Justin Kramer, on compatibility and direction for > java.jdbc and HoneySQL at Clojure/conj last year) > > On Fri, Jul 5, 2013 at 3:59 AM, r0man <roman.sche...@burningswell.com> > wrote: > > Hi Carlo, > > > > if you'are looking for generating more complex SQL there's also: > > > > https://github.com/r0man/sqlingvo > > > > Roman. > > > > On Wednesday, July 3, 2013 10:48:07 AM UTC+2, Carlo wrote: > >> > >> Hey guys! > >> > >> I've been working on a small library to make writing SQL queries a > little > >> bit easier. It's along the same lines as ClojureQL, but takes a > different > >> approach and compiles into quite different SQL in the end. > >> > >> At the moment it's quite immature, but it should be able to support any > >> queries which can be expressed in relational algebra. There will be > some SQL > >> queries which can't be expressed in clojure-sql, but hopefully there > won't > >> be too many of those. A greater limitation is that at the moment the SQL > >> generation is specific to the PostgresSQL database (although any > >> contributions for other databases are welcome!). > >> > >> Dependency vector: [clojure-sql "0.1.0"] > >> Repository: https://bitbucket.org/czan/clojure-sql > >> Clojars link: https://clojars.org/clojure-sql > >> > >> Let me know what you think! > >> > >> Carlo > > > > -- > > -- > > You received this message because you are subscribed to the Google > > Groups "Clojure" group. > > To post to this group, send email to clojure@googlegroups.com > > Note that posts from new members are moderated - please be patient with > your > > first post. > > To unsubscribe from this group, send email to > > clojure+unsubscr...@googlegroups.com > > For more options, visit this group at > > http://groups.google.com/group/clojure?hl=en > > --- > > You received this message because you are subscribed to the Google Groups > > "Clojure" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to clojure+unsubscr...@googlegroups.com. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > > > -- > Sean A Corfield -- (904) 302-SEAN > An Architect's View -- http://corfield.org/ > World Singles, LLC. -- http://worldsingles.com/ > > "Perfection is the enemy of the good." > -- Gustave Flaubert, French realist novelist (1821-1880) > > -- > -- > You received this message because you are subscribed to the Google > Groups "Clojure" group. > To post to this group, send email to clojure@googlegroups.com > Note that posts from new members are moderated - please be patient with > your first post. > To unsubscribe from this group, send email to > clojure+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/clojure?hl=en > --- > You received this message because you are subscribed to the Google Groups > "Clojure" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to clojure+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to clojure@googlegroups.com Note that posts from new members are moderated - please be patient with your first post. To unsubscribe from this group, send email to clojure+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/clojure?hl=en --- You received this message because you are subscribed to the Google Groups "Clojure" group. To unsubscribe from this group and stop receiving emails from it, send an email to clojure+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
