Ability to use OR in Alert query WHERE

[KieranP]

I have an alert that needs to run when deployment_environment = production OR client_name = demo.

But the current implementation of the query builder appears to join WHERE parts with AND.

So it would be nice if the WHERE part of the query builder supported using OR between query parts.

e.g. WHERE: deployment_environment = production OR client_name = demo

Is the only way to achieve this by writing a custom clickhouse query? If so, is there a way to convert the current alert query builder into a matching CH SQL query so I don't have to start from scratch?