Is there any library to represent SQL queries as objects in Java code? [closed]

Question

I was wondering if there is any library that can be used to represent SQL queries as objects in Java.

In the code I have plenty of static variables of type java.lang.String that are hand written SQL queries. I would be looking for library having a nice fluent API that allows me to represent the queries as objects rather than strings.

Example:

Query q = select("DATE", "QUOTE")
  .from("STOCKMARKET")
  .where(eq("CORP", "?"))
  .orderBy("DATE", DESC);

Answer 1

Querydsl supports querying on SQL, JPA and JDO backends.

The example above becomes :

query.from(stockmarket).where(stockmarket.corp.eq(someVar))
    .orderBy(stockmarket.date.desc())
    .list(stockmarket.date, stockmarket.quote);

Querydsl uses code generation via APT to mirror an SQL schema to Java query types. This way the queries are fully type-safe (or "schema-compliant" with SQL).

I am the maintainer of Querydsl, so this answer is biased.

I published a comparison of Querydsl to other frameworks here.

Answer 2

These are some good proprietary libraries to create typesafe SQL queries dynamically

• jOOQ: http://www.jooq.org (of which I am the developer)
• QueryDSL: http://www.querydsl.com
• JaQu: http://www.h2database.com/html/jaqu.html
• iciql: http://iciql.com/ (a friendly fork of JaQu)
• Quaere: http://quaere.codehaus.org
• Jequel: http://www.jequel.de (in maintenance mode, I think)
• Squiggle: http://code.google.com/p/squiggle-sql (in maintenance mode, I think)

Apart from the above, there is always

• Hibernate/JPA CriteriaQuery
• MyBatis

Your example in jOOQ:

create.select(DATE, QUOTE)
      .from(STOCKMARKET)
      .where(CORP.equal(123))
      .orderBy(DATE.desc());