But dynamic recipient resolution from an external DB isn't currently a native email-destination feature. A webhook is the cleanest way to implement the routing without creating hundreds of alerts/destinations.

Hi Simran, I tried using SQL Alerts and have attached our requirement for reference. We have multiple test benches, and each bench can have multiple subscribed email addresses. These benches generate a large volume of logs, which are monitored through OpenObserve. Whenever an error is detected in the logs of a specific bench, a notification should be sent only to the email recipients subscribed to that particular bench. This ensures that alerts are routed to the appropriate stakeholders responsible for the affected bench. Please let me know if SQL Alerts can support this use case or if there is a recommended approach to achieve it. Thanks, Vijay