How best to handle errors that come from database constraints?

[mfelix5]

Using the starter, if you have a service function do something that violates a database constraint (for example on uniqueness or table relationships), the error is uncaught and the API returns a 500. What is a good strategy for catching these errors and returning a 4xx and a better error message?

[ljlm0402]

@mfelix5

Thanks for the good comment.
Let's think of a better way.