[Dovecot] multiple password schemes and sql?

Hello all.

Just about to migrate from courier to dovecot, and figured I would as well try and get this working so I could use non plaintext mechanisms as well.

I would like to offer at least: plain login digest-md5 cram-md5 and maybe more

Everything works but this and have a testdb in sql with passwords like userid, password

But get "Password query returned multiple matches" which indicates it doesnt try using any prefix and just get a hit on all "passwords" for that user.

Is there any variable I can use in the sql query to use an extra field that contains the password type?

plain and login should be stored in some crypted form, probably as md5 or sha256 hashes.

Thankful for any insight into this...