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.

---

Table of contents

• SELECT
• INSERT
• UPDATE
• DELETE
• CREATE TABLE