Support custom SQL in searches + alerts #1362
Description
Coming from other tools, hyperdx feels quite rigid. It would go along way to support custom queries for searches (and maybe charts). The custom queries should also support alerting functionality. We use custom queries and alerts on those in axiom, for example. While I think it's good to strive for having high-level UI primitives for most things, I don't think that'll cover 100% of user needs, so it would be very powerful to allow folks to write custom queries and setup alerts over those queries.
This is maybe not the best example, but I was trying to calculate rate. The screenshot below demonstrates a few issues:
- Sort of working, but verry clunky to put in custom SQL
- bug: adds my default fields to select even though I removed them
- bug: adds order by even though I removed it
- Because it adds order by and other fields, query doesn't work
