Builder

The builder module provides a fluent API for composing SQL statements with method chaining, filters, and dialect-aware compilation.

Queries

SELECT, INSERT, UPDATE, DELETE, and MERGE builders.

Queries
DDL

CREATE TABLE, ALTER TABLE, DROP, indexes, views, and schemas.

DDL
Expressions

Column definitions, function columns, aggregates, and expression wrappers.

Expressions
Factory

SQLFactory entry point and BuiltQuery result type.

Factory

Quick Reference

Builder

Purpose

Page

SQLFactory

Entry point for all builders

Factory

Select

SELECT queries with joins, CTEs, window functions

Queries

Insert

INSERT with values, from-select, conflict handling

Queries

Update

UPDATE with SET, FROM, WHERE

Queries

Delete

DELETE with WHERE, RETURNING

Queries

Merge

MERGE / UPSERT operations

Queries

CreateTable

DDL table creation

DDL

AlterTable

DDL table modification

DDL

Column

Column expressions and aliases

Expressions