Query Builder Guide

The fluent builders are intended for teams that want readable query composition without giving up SQL control.

Supported Patterns

The current builder surface supports:

• joins
• subqueries in FROM and JOIN
• CTE and recursive CTE
• UNION, UNION ALL, INTERSECT, and EXCEPT
• WHERE EXISTS and WHERE IN subquery helpers
• grouping, aggregates, and HAVING
• window functions
• pagination
• insert, update, delete, upsert, and RETURNING

Parameter Handling

The builders keep SQL text and parameter values separate.

For PostgreSQL, ? placeholders are mapped to $1, $2, $3, and so on before execution.

Good Entry Points To Search

• SqliteQueryBuilder
• PostgresQueryBuilder
• QueryBuildResult
• QueryRunResult
• agg

Practical Rule

Use the builder when you want:

• fluent composition
• parameter safety
• guided validation errors
• predictable SQL generation

Use raw SQL fragments only when the query shape goes beyond what the fluent API currently models cleanly.