Question 1

How to use HoneySQL with next.jdbc to execute queries?

Accepted Answer

HoneySQL generates parameterized SQL strings that you can pass directly to next.jdbc's execute! function. For example, (jdbc/execute! conn (sql/format sqlmap)) as shown in the README, ensuring safe query execution with parameter binding.

Question 2

HoneySQL vs Korma: which is better for Clojure SQL?

Accepted Answer

HoneySQL focuses on SQL generation using a data DSL, offering fine-grained control and composability, while Korma is an ORM-like library with higher-level abstractions. Choose HoneySQL for raw SQL flexibility and Korma for more declarative, schema-driven approaches.

Question 3

Can HoneySQL handle PostgreSQL JSONB types in queries?

Accepted Answer

Yes, but you need to use the :lift syntax or named parameters (:param) to pass structured data like vectors or maps as values, since HoneySQL might otherwise interpret them as part of the DSL, as explained in the Nested Subqueries section.

Question 4

How to build dynamic WHERE clauses with conditional logic in HoneySQL?

Accepted Answer

Use the where helper function with cond-> to conditionally add clauses, as demonstrated in the README with examples like (cond-> id (where [:= :id id])), allowing programmatic query construction based on runtime conditions.

Question 5

Is HoneySQL compatible with ClojureScript and Babashka?

Accepted Answer

Yes, HoneySQL supports recent versions of ClojureScript and Babashka, enabling SQL generation in those environments. However, some features like the macro for local substitution are Clojure-only, as noted in the README.

Question 6

What are the main differences between HoneySQL 1.x and 2.x?

Accepted Answer

Version 2.x has a streamlined codebase, simpler extension methods, and built-in SQL dialect support, while 1.x is legacy and lacks these features. They can be used side-by-side with different namespaces, but migration is recommended for new projects.

Question 7

How to add custom SQL functions or operators in HoneySQL?

Accepted Answer

Use the register-fn! function to define new SQL functions, providing a formatter that handles syntax and parameters, as shown in the Extensibility section. This allows integration of database-specific features without forking the library.

honeysql

What is honeysql?

Overview

Use Cases

Best For

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions