Liquibase changesets ↔ PostgreSQL: Pagination of large queries
Goal During a data‑migration Liquibase changesets often need to process millions of rows. The objective is to use a pagination strategy (LIMIT/OFFSET or cursor‑based) within a changeset so that each batch fits comfortably into a single transaction and does not lock the entire table. Constraints Liquibase’s <sql> and <sqlFile> tags accept raw SQL,