Investigate if possible to detect password prompt during connection

[rach]

Ideally I would like to mimic the psql behavior as possible, so being able to detect that the password is required and prompt the user sounds like the ideal solution