ES|QL (Elasticsearch Query Language)

# Temel ES|QL sorgusu
curl -X POST "http://localhost:9200/_query" -H "Content-Type: application/json" -d'
{
  "query": "FROM products | WHERE price > 1000 AND is_active == true | STATS avg_price = AVG(price), count = COUNT(*) BY category | SORT avg_price DESC | LIMIT 10"
}'

# Zaman serisi analizi
curl -X POST "http://localhost:9200/_query" -H "Content-Type: application/json" -d'
{
  "query": "FROM logs-* | WHERE @timestamp > NOW() - 1 hour | STATS error_count = COUNT(*) BY host, status_code | WHERE error_count > 100 | SORT error_count DESC"
}'

# Full-text search in ES|QL
curl -X POST "http://localhost:9200/_query" -H "Content-Type: application/json" -d'
{
  "query": "FROM products | WHERE MATCH(description, "spor ayakkabı") | KEEP name, price, category, _score | SORT _score DESC | LIMIT 20"
}'

// ES|QL with .NET client
public async Task<List<CategoryReport>> GetCategoryReportAsync()
{
    var response = await _client.Esql.QueryAsync(q => q
        .Query("FROM products | WHERE is_active == true | STATS avg_price = AVG(price), total = COUNT(*), total_stock = SUM(stock) BY category | SORT total DESC | LIMIT 20")
        .Format("json"));

    // Parse response columns and values
    return response.Columns.Any()
        ? ParseEsqlResponse<CategoryReport>(response)
        : new List<CategoryReport>();
}