@codekagefx in my opinion it comes down to developer preference - you can handle both or just one -/ if I were to use just one approach Iโll just handle unique constraint errors on the table - but honestly both approaches do the same thing.
I have this thing where my brain inflates the complexity of a concept before diving into it which can discourage me or make me procrastinate , only to finally dive into it and discover there was nothing complex in the first place :(