where builder, joins

[konmik]

I like your library, however I would like to see "where" builder.

How about having such syntax?

result = select(all)
    .from(tableName)
    .where(
        and(
            eq(NAME, "Joe"),
            eq(AGE, 99)))
    .limit(5)
    .executeOn(statementExecutor);

This will allow to mix several where clauses received from different sources.

In example, I can create AccountDao interface that is bound to a given account Id. I will be able to join all queries with and(requiredStatement, eq(ACCOUNT_ID, accountId)).

Joins are also a common thing that is needed.