Builder API

Write Conflicts

Ignore generates INSERT IGNORE; Update generates INSERT ... ON DUPLICATE KEY UPDATE. The table's primary and unique constraints determine conflicts, not just the primary key marked in the entity.

IGNORE can also turn data errors into warnings, so do not use it to validate input. See Insert Conflicts for configuration and examples.

Pagination

initPage(pageSize, pageNumber) generates LIMIT offset, size. Page numbers start at 0. Pagination iteration fetches successive pages; order by a unique field for stable paging.

A separate count query obtains the total. See Pagination.