Investigate if possible to detect password prompt during connection #9
Description
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