Map SQL errors to Fuego error: create packages in /extra

[EwenQuim]

Is your feature request related to a problem? Please describe.

Mapping sql errors to fuego errors is so nice, it helps a lot readability.

Describe the solution you'd like

An extra package for sqlite that looks like this

// In `extra` package
func SQLiteErrorHandler(err error) error {
	var sqliteError *sqlite.Error
	if errors.As(err, &sqliteError) {
		sqliteErrorCode := sqliteError.Code()
		switch sqliteErrorCode {
		case 1555, 2067 /* UNIQUE constraint failed */ :
			return fuego.ConflictError{Title: "Duplicate", Detail: sqliteError.Error(), Err: sqliteError}
		default:
			return fuego.InternalServerError{Title: "Internal Server Error", Detail: sqliteError.Error(), Err: sqliteError}
		}
	}

	return err
}

// USAGE
func customErrorHandler(err error) error { 
	return fuego.ErrorHandler(SQLiteErrorHandler(err)) 
}

fuego.NewServer(
  fuego.WithEngineOptions(
    fuego.WithErrorHandler(customErrorHandler),
  )
)

Also please make an extra package for SQL that maps common sql errors like sql.ErrNoRows to fuego.NotFoundError

[dotandev]

Can I handle this task?

[GideonBature]

I'd like to handle this task.

[EwenQuim]

You two can take this issue!

I won't assign you to make sure nobody's blocked to create their PR. I'll assign you after you create your draft PR.