Refactor: Update pnpm-lock.yaml and enhance job recovery in queues

Commit notes

This commit downgrades the lockfile version in `pnpm-lock.yaml` for compatibility and introduces a job recovery mechanism in the queue system. Key changes include:

- **Lockfile Update:** Downgraded `lockfileVersion` to '6.0' in `pnpm-lock.yaml`. - **Job Recovery:** Implemented `recoverStaleJobs` method in the queue class to handle stale jobs on startup, ensuring that jobs stuck in processing are moved back to the waiting queue or marked as dead if max attempts are reached. - **Logging Enhancements:** Added logging for recovered jobs to improve visibility during job recovery.

Additionally, several unused SQL files and snapshots have been removed to streamline the codebase.