[jakozaur]

You are right. SQL is the best language, but it likely needs some extensions. See SQL with pipe syntax. Read Google paper or try it out in Big Query.

There are a lot of fundamentals in observability, but there are very verbose in SQL:

- rate operator, which translates absolute value to rate, possible with SQL and window functions, but takes many lines of code

- pivot, where you like to see the top 5 counts of errors of most hit-by-error microservices plus others over time

- sampling is frequent in observability and will be useful for LLMs, it is a one-liner in SQL with pipe syntax, even customizing specific

I actually believe LLM gen AI plays extremely well with pipe syntax. It allows us to feed partial results to LLM, sampling as well as show how LLM is evolving queries over time. SQL troubleshooting is not a single query but a series of them.

Still, SQL with pipe syntax is just syntactical sugar on SQL. It let's you use all SQL features as well as compiles to SQL.