What are some more options or good practices for dynamic SQL query building?

• honeysql

  16 1,702 8.6 Clojure

  Turn Clojure data structures into SQL

• JDBI

  27 1,901 9.4 Java

  The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.

  

I really like JDBI. It’s thin enough that it lets you do anything SQL can do, but opinionated enough to provide a sane, sturdy, structured approach to working with a database.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• sequel

  1 2 10.0 Java

  Sequel: a Java query builder (by henryx)

Time ago, I've started the build of my own query builder, which covers cases like your. Query result is generated in programmatic way and the initial intention was oi use with JDBI . If you want to look it, code is in https://github.com/henryx/sequel

• ormlite

  2 1,579 0.0 Java

  ORMLite Android functionality used in conjunction with ormlite-core

I liked this one https://ormlite.com/

• spring-data-relational

  11 728 9.1 Java

  Spring Data Relational. Home of Spring Data JDBC and Spring Data R2DBC.

  

I would ignore the hipster jOOQ and similar and start with Spring Data JDBC https://spring.io/projects/spring-data-jdbc

• ElSql

  1 100 1.2 Java

  Manage external SQL files in Java with a little DSL goodness

  

You could use https://github.com/OpenGamma/ElSql for this. It's compatible with NamedParameterJdbcTemplate and allows for enough dynamism to solve common problems without rewriting your entire query.

Suggest a related project