When using SQLBoiler with Postgres DB, you will eventually need to react to unique constraint violations in a constructive manner:

postgresUniqueConstraintErrorHandlingWithSQLBoiler.go

  logger := zap.NewNOP()
  err = pilot.Insert(ctx, m.DB.Master(), boil.Infer())
	switch err := errors.Cause(err).(type) {
	case nil:
		// Carry on

	case *pq.Error:
		if err.Code.Name() == "unique_violation" && err.Constraint == "unique_constraint_name" {
			// Do something
			return nil
		}

		logger.Error("Failed to save pilot",
			zap.Error(err),
			zap.String("pq_err_code", string(err.Code)),
			zap.String("pq_err_code_name", err.Code.Name()))

		return errors.Wrap(err, "failed save pilot")

	default:
		logger.Error("Failed to save pilot",
			zap.Error(err),
			zap.String("error_type", fmt.Sprintf("%T", err)),
			zap.String("error_detail", fmt.Sprintf("%#v", err)))

		return errors.Wrap(err, "failed save pilot")
	}

Using fields on your logger to print relevant info and also wrapping the errors returned with stack and additional message