chores(pgproto): simplify error handling

Summary

• chores(sql): remove useless error mapping and type specs

• chores(pgproto): simplify PgError

---

• Close #...
• Changes should be cherry-picked to 24.2: yes / no
• Docs follow-up: not necessary / new issue