result:
  _jsonata:
    expr: '$.users[status="active"].name'
    data:
      _request: getData

$.name              // Get name field
$.address.city      // Nested field
$.items[0]          // Array index

$.users[age > 18]           // Filter by condition
$.products[price < 100]     // Numeric comparison
$.items[type="book"]        // String match

$.users.name                // Get all names
$.orders.(quantity * price) // Calculate for each

$sum($.items.price)         // Sum
$count($.users)             // Count
$average($.scores)          // Average
$max($.values)              // Maximum

$uppercase($.name)          // UPPERCASE
$lowercase($.name)          // lowercase
$trim($.text)               // Trim whitespace
$join($.tags, ', ')         // Join array

activeUserNames:
  _jsonata:
    expr: '$.users[active=true].name'
    data:
      _request: getUsers

orderTotal:
  _jsonata:
    expr: '$sum($.items.(quantity * unitPrice))'
    data:
      _state: order

summary:
  _jsonata:
    expr: |
      {
        "totalOrders": $count($.orders),
        "totalRevenue": $sum($.orders.amount),
        "averageOrder": $average($.orders.amount)
      }
    data:
      _request: getOrders