javaica/querier

Simple SQL query builder

Querier

Simple yet useful SQL query builder that simplifies query creation by restricting operator order.

The purpose of this project is to create really easy-to-use solution for query building so that if the code compiles, then query operators are valid (not counting content, of course).

Usage

String query = new Querier()
                .select("col1", "col2")
                .from("Table1")
                .where("col1 > 0")
                .build();

Result:

SELECT col1, col2 FROM Table1 WHERE col1 > 0

Aliases:

String query = new Querier()
                .select("column1").as("first")
                .select("column2").as("second")
                .from("Table1")
                .build();

Result:

SELECT column1 AS first, column2 AS second FROM Table1

String query = new Querier()
                .select("t1.col1", "t2.col2", "t3.col3")
                .from("Table1").as("t1")
                .leftJoin("Table2").as("t2")
                .on("t2.col2 = t1.col1")
                .join("Table3").as("t3")
                .on("t3.col3 > t1.col1")
                .build();

Result:

SELECT t1.col1, t2.col2, t3.col3 FROM Table1 AS t1 LEFT JOIN Table2 AS t2 ON t2.col2 = t1.col1 JOIN Table3 AS t3 ON t3.col3 > t1.col1

Querier querier = new Querier();
String query = querier
                .select("col1")
                .distinct()
                .from("T001")
                .leftJoin("T002")
                .on("2 < 1")
                .join("T003")
                .on("1 > 2")
                .where("col1 > 0").and("col1 < 10")
                .groupBy("col1")
                .having("col1 > 0").or("col2 > 0")
                .orderBy("col2")
                .limit(1)
                .offset(2)
                .build();

Query syntax customizing

Query syntax can be customized by creating custom SyntaxProvider and passing it to QueryBuilder

SyntaxProvider provider = new DefaultSyntaxProvider() {
    @Override
    public String delimiter() {
        return "\n";
    }
};
Querier querier = new Querier(provider);
String query = querier
        .select("col1")
        .from("T001")
        .build();

Result:

SELECT col1
FROM T001

License

The project is licensed under MIT License.