Queries
QueryBuilder is the entry point for all statement types. It provides a fluent API for SELECT queries on its instance, and static factory methods that return dedicated builder objects for DML and DDL statements.
Statement types
| Statement | Builder | Entry point |
|---|---|---|
| SELECT | QueryBuilder | new QueryBuilder() |
| INSERT | InsertBuilder | QueryBuilder.insertInto(table) |
| UPDATE | UpdateBuilder | QueryBuilder.update(table) |
| DELETE | DeleteBuilder | QueryBuilder.deleteFrom(table) |
| CREATE TABLE | CreateBuilder | QueryBuilder.createTable(table) |
SqlResult
Every builder returns a SqlResult from its build() or buildSql() method:
| Method | Returns | Description |
|---|---|---|
getSql() | String | The rendered SQL with ? placeholders |
getParameters() | List<Object> | Bind parameters in order of appearance |
All user-supplied values are placed in the ? bind-parameter list and are never concatenated into the SQL string. See SQL Dialects for how identifier quoting behaves across database targets.