Upgrade go version, gomock dependency and pgx version

[jairogloz]

Description

• Pretty much the same proposed here Any plans to update to github.com/jackc/pgx/v5? #10
• The github.com/golang/mock repository was archived by the owner on Jun 27, 2013. One has to go to go.uber.org/mock for a maintained fork.
• As go.uber.org/mock depends on go 1.22 we might as well upgrade the go version
• Upgrade github.com/jackc/pgx/v4 to v5

Motivation

Keeping the repository updated ensures that we:

1. Leverage Actively Maintained Tools: Migrating to the maintained go.uber.org/mock ensures compatibility with future Go versions, bug fixes, and security updates.
2. Adopt Modern Go Features: By upgrading to Go 1.22, we can take advantage of performance improvements, new language features, and better tooling support.
3. Reduce Technical Debt: Using outdated dependencies increases maintenance overhead and risks compatibility issues. Upgrading now prevents future disruptions and aligns with best practices.
4. Stay Aligned with the Community: Transitioning to go.uber.org/mock aligns us with the broader Go community, as the fork is now the standard for mock generation.

This proactive approach ensures the long-term health and maintainability of the codebase.