Have a Stmt interface gives developer more controls when writing database related tools. It would be nice to to be able to create a custom stmt struct that has the same method signatures as sql.Stmt but with some custom instructions inside each method. For example, when writing a DB wrapper for handling database read replicas, the statement may need to be prepared in multiple db pools, to provide a seamless feel for the end users, I woulld like the users to call the Prepare() or PrepareContext() as if they are using database/sql.DB.

example usecase

In some rare cases we would like to include some custom errors when using QueryRow. Take read replica situation as an example again, if the tool wants to provide the custom QueryRow function but need to capture certain errors, it would be nice to return a Row interface instead of panicing.

example usecase