feat: error translator support

[saeidee]

• [x] Do only one thing
• [x] Non breaking API changes
• [x] Tested

What did this pull request do?

This PR adds support for translating Postgres errors like unique key violation to native gorm errors (ErrDuplicatedKey)

Related PR in gorm repo: https://github.com/go-gorm/gorm/pull/6004