[FR] - When using Email/Password authentication, add a way to login with the password

**Is your feature request related to a problem? Please describe.**
There is a problem with the SDK. Although it offers the option to use email and password for authentication, I cannot locate any means to authenticate with a password in the auth.py file. Therefore, this method does not exist.

**Describe the solution you'd like**
Add an additional function called "get_user_password_hash_by_email" or "verify_hash_by_email" in order to verify if the current user's password matches.

**Additional context**
There isn't much context for this, but it's quite straightforward. I would be happy to assist if necessary.

Start in auth.py and inspect the existing email/password authentication API and related tests, if present. Determine whether password verification is supported by the SDK and clarify the public API and security constraints; done means the agreed behavior is implemented and covered by tests.

Written by the indexing model from the issue text.