The idea of having only one method, which itself decides whether you want to do a SELECT, INSERT or UPDATE is rather well-found.

On the other hand, the fact that you can only search on "equal" and not on "like" or other operators, seems artificially limiting. Id. goes for only using "AND" between search terms.

Perhaps if one provided a scalar instead of a hash ref as second argument, this would signal that in this scalar is to be found a verbatim "WHERE"-clause to be used as such.

Mind you , it would make your module less secure as it would be possible to inject arbitrary SQL-code into the statement!