[Dovecot] multiple password schemes and sql?

[R A]

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...