It should be possible to define hosts in a maintenance period from their membership of multiple host groups, like:
Activate maintenance period if host is member of: Customer_foo AND (Dev_apache OR Dev_sql)