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.
DDL
CREATE TABLE, ALTER TABLE, DROP, indexes, views, and schemas.
Expressions
Column definitions, function columns, aggregates, and expression wrappers.
Factory
SQLFactory entry point and BuiltQuery result type.
Quick Reference¶
Builder |
Purpose |
Page |
|---|---|---|
|
Entry point for all builders |
|
|
SELECT queries with joins, CTEs, window functions |
|
|
INSERT with values, from-select, conflict handling |
|
|
UPDATE with SET, FROM, WHERE |
|
|
DELETE with WHERE, RETURNING |
|
|
MERGE / UPSERT operations |
|
|
DDL table creation |
|
|
DDL table modification |
|
|
Column expressions and aliases |