[Dovecot] Site-wide configurable Sieve

Hi,

I need some sieve actions to be specified per-user, but exposing actual sieve scripts to users is of the question.

For example, I need to be able to either put spam messages into a spam folder, or discard them, based on user preference. Presumably this would be done using Sieve. As I understand, it's not possible to query a database from within a sieve script.

If I can't use a single global script, I can imagine automatically generating per-user scripts when settings are saved in a GUI (e.g. webmail) and store them on the dovecot machine. This would work but I would love to hear if someone has a smarter, more robust idea.

Thanks,

Gedalya