Colin, This is a great question, and I concede that the compose-ability of HoneySQL (and other DSLs) is almost always going to best HugSQL for the simple reason that a Lisp is a better tool for composing than SQL is.
You could feasibly accomplish some composable queries by using HugSQL's Raw SQL parameter type <http://www.hugsql.org/#param-sql>. That seems a bit clunky to me at scale, and I'm not sure I'd recommend it. HugSQL is a month old, and I'm open to adding additional features that would improve HugSQL's composable abilities. This might include something like SQL snippet functions and snippet parameter types. All feedback is welcome! Thanks, Curtis On Wed, Nov 11, 2015 at 8:09 PM, Colin Yates <colin.ya...@gmail.com> wrote: > Congrats Curtis - this looks great. > > I do have one question: you compare in http://www.hugsql.org/#faq-dsls > HugSQL with HoneySQL, however, the one killer feature that I use HoneySQL > for is composable queries - or rather building up the Clojure data map > through composition before rendering it as SQL. Is there an equivalent > capability in HugSQL? > > As a trivial example, I need to be able to add joins to the query in > response to the filters the user passes through. Equally, I will apply a > “top X” if the user has specified that in their request and so on. > > Please don’t read this as ‘Honey SQL can do this, you can’t na na nana na’ > :-) It isn’t, simply asking for clarity as that comment in the page bought > the two into comparison. > > Thanks, and again, congratulations! > > On 12 Nov 2015, at 00:51, Curtis Summers <curtis.summ...@layerware.com> > wrote: > > I'm happy to announce the 0.3.0 release of HugSQL. > > HugSQL is a Clojure library for embracing SQL in your projects. > > This is a significant release because of the new documentation site: > > http://www.hugsql.org/ > > Recent changes from 0.2.x to 0.3.0 include: > > - New doc site! > - Comparison to Yesql (on doc site) - this was requested by many > - Example application as source for doc examples (*The Princess Bride* > themed!) > - Tuple List Parameter Type for multi-record insert support > - Pass-through options to the underlying database library (e.g., > :as-arrays?) > - Defer adapter selection as late as possible > - Added on-exception to HugsqlAdapter protocol to allow > implementations to redirect exceptions (helps with usage in core.async > channels) > - Error checks for sql file existence, parameter mismatch errors > - Minor bug fixes > > I'd like to give special thanks to Robin Heggelund Hansen, who jumped in > early on filing issues, writing code, and making good suggestions for this > very new project. Robin is also the author of the HugSQL Adapter for > postgres.async <https://github.com/Skinney/hugsql-async>. > > What is HugSQL? HugSQL... > > - takes the position that SQL is the right tool for the job when > working with a relational database. > - uses simple conventions in your SQL files to define (at compile > time) database functions in your Clojure namespace, creating a clean > separation of Clojure and SQL code. > - supports run-time replacement of SQL Value Parameters (e.g., where > id = :id), SQL Identifiers (i.e. table/column names), and SQL Keywords. You > can also implement your own parameter types. > - has protocol-based adapters supporting multiple database libraries > and ships with adapters for clojure.java.jdbc (default) and clojure.jdbc > > > Thanks! > > Curtis Summers > > -- > 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/d/optout. > > > -- > 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 a topic in the > Google Groups "Clojure" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/clojure/1vezOq3Ro78/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > clojure+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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/d/optout.
