AQL queries typically access one or more collections to read from documents or to modify them. Queries don’t necessarily have to involve collections however. Below are a few examples of that.

Following is a query that returns a string value. The result string is contained in an array because the result of every valid query is an array:

RETURN "this will be returned"
Show output
[ 
  "this will be returned" 
]

You may use variables, call functions and return arbitrarily structured results:

LET array = [1, 2, 3, 4]
RETURN { array, sum: SUM(array) }
Show output
[ 
  { 
    "array" : [ 
      1, 
      2, 
      3, 
      4 
    ], 
    "sum" : 10 
  } 
]

Language constructs such as the FOR loop can be used too. Below query creates the Cartesian product of two arrays and concatenates the value pairs:

FOR year IN [ 2011, 2012, 2013 ]
  FOR quarter IN [ 1, 2, 3, 4 ]
    RETURN {
      year,
      quarter,
      formatted: CONCAT(quarter, " / ", year)
    }
Show output
[ 
  { 
    "year" : 2011, 
    "quarter" : 1, 
    "formatted" : "1 / 2011" 
  }, 
  { 
    "year" : 2011, 
    "quarter" : 2, 
    "formatted" : "2 / 2011" 
  }, 
  { 
    "year" : 2011, 
    "quarter" : 3, 
    "formatted" : "3 / 2011" 
  }, 
  { 
    "year" : 2011, 
    "quarter" : 4, 
    "formatted" : "4 / 2011" 
  }, 
  { 
    "year" : 2012, 
    "quarter" : 1, 
    "formatted" : "1 / 2012" 
  }, 
  { 
    "year" : 2012, 
    "quarter" : 2, 
    "formatted" : "2 / 2012" 
  }, 
  { 
    "year" : 2012, 
    "quarter" : 3, 
    "formatted" : "3 / 2012" 
  }, 
  { 
    "year" : 2012, 
    "quarter" : 4, 
    "formatted" : "4 / 2012" 
  }, 
  { 
    "year" : 2013, 
    "quarter" : 1, 
    "formatted" : "1 / 2013" 
  }, 
  { 
    "year" : 2013, 
    "quarter" : 2, 
    "formatted" : "2 / 2013" 
  }, 
  { 
    "year" : 2013, 
    "quarter" : 3, 
    "formatted" : "3 / 2013" 
  }, 
  { 
    "year" : 2013, 
    "quarter" : 4, 
    "formatted" : "4 / 2013" 
  } 
]