Errors with push mode / SQLite in development

Describe the Bug

During development whenever fields are changed in collections I intermittently get errors such as:

 ⨯ [Error [LibsqlError]: SQL_INPUT_ERROR: SQLite input error: table `payload_locked_documents_rels` already exists (at offset 13)] {
  code: 'SQL_INPUT_ERROR',
  rawCode: undefined,
  digest: '3770172395',
  [cause]: [Error [ResponseError]: SQLite input error: table `payload_locked_documents_rels` already exists (at offset 13)] {
    code: 'SQL_INPUT_ERROR',
    proto: {
      message: 'SQLite input error: table `payload_locked_documents_rels` already exists (at offset 13)',
      code: 'SQL_INPUT_ERROR'
    }
  }
}

OR

 ⨯ [Error [LibsqlError]: SQLITE_UNKNOWN: SQLite error: index payload_locked_documents_rels_order_idx already exists] {
  code: 'SQLITE_UNKNOWN',
  rawCode: undefined,
  payloadInitError: true,
  digest: '1406407794',
  [cause]: [Error [ResponseError]: SQLite error: index payload_locked_documents_rels_order_idx already exists] {
    code: 'SQLITE_UNKNOWN',
    proto: {
      message: 'SQLite error: index payload_locked_documents_rels_order_idx already exists',
      code: 'SQLITE_UNKNOWN'
    }
  }
}
 ⨯ [Error [LibsqlError]: SQLITE_UNKNOWN: SQLite error: index payload_locked_documents_rels_order_idx already exists] {
  code: 'SQLITE_UNKNOWN',
  rawCode: undefined,
  payloadInitError: true,
  digest: '1406407794',
  [cause]: [Error [ResponseError]: SQLite error: index payload_locked_documents_rels_order_idx already exists] {
    code: 'SQLITE_UNKNOWN',
    proto: {
      message: 'SQLite error: index payload_locked_documents_rels_order_idx already exists',
      code: 'SQLITE_UNKNOWN'
    }
  }
}
 ⨯ [Error [LibsqlError]: SQLITE_UNKNOWN: SQLite error: index payload_locked_documents_rels_order_idx already exists] {
  code: 'SQLITE_UNKNOWN',
  rawCode: undefined,
  payloadInitError: true,
  digest: '1406407794',
  [cause]: [Error [ResponseError]: SQLite error: index payload_locked_documents_rels_order_idx already exists] {
    code: 'SQLITE_UNKNOWN',
    proto: {
      message: 'SQLite error: index payload_locked_documents_rels_order_idx already exists',
      code: 'SQLITE_UNKNOWN'
    }
  }
}

requiring me to reload the project and waste a lot of time

Link to the code that reproduces this issue

https://github.com/mkrn/payloadcms_reproduction

Reproduction Steps

• Start in dev mode, init db and login to admin
• Add an array field or change an array field in Pages collection
• See admin (Pages collection page)
• See errors in console

Which area(s) are affected? (Select all that apply)

db-sqlite

Environment Info

Binaries:
  Node: 20.9.0
  npm: 10.1.0
  Yarn: 4.5.3
  pnpm: 9.15.1
Relevant Packages:
  payload: 3.31.0
  next: 15.2.3
  @payloadcms/email-nodemailer: 3.31.0
  @payloadcms/graphql: 3.31.0
  @payloadcms/next/utilities: 3.31.0
  @payloadcms/payload-cloud: 3.31.0
  @payloadcms/richtext-lexical: 3.31.0
  @payloadcms/translations: 3.31.0
  @payloadcms/ui/shared: 3.31.0
  react: 19.0.0
  react-dom: 19.0.0
Operating System:
  Platform: darwin
  Arch: arm64
  Version: Darwin Kernel Version 23.6.0: Sun Jun 30 19:41:22 PDT 2024; root:xnu-10063.140.33~20/RELEASE_ARM64_T6000
  Available memory (MB): 16384
  Available CPU cores: 10