templates/default/sql/db_virtual_alias_domain_mailbox_maps.cf.erb
# Generated by Chef
user = <%= @user %>
password = <%= @password %>
hosts = <%= @host %>
dbname = <%= @dbname %>
query = SELECT maildir FROM mailbox,alias_domain WHERE alias_domain.alias_domain = '%d' and mailbox.username = CONCAT('%u', '@', alias_domain.target_domain) AND mailbox.active = true AND alias_domain.active = true