Both support reading and modifying collection data, however AQL does not support data definition operations, such as creating and dropping databases, collections and indexes.
Though some of the keywords overlap, AQL syntax differs from SQL.
By commenting, you are accepting the IBM commenting guidelines and the DISQUS terms of service.
The Arango DB Query Language (AQL) is similar to the Structured Query Language (SQL) in its purpose.
SQL Server Execution Times: CPU time = 0 ms, elapsed time = 1 ms.
If we compare the statistics time and statistics i/o from the the update with the identity column to this approach the overall number of logical reads is just about the same, but the overall duration is about 10 times faster doing the update versus having to maintain the identity value.
This can be seen here (SET @id = id = @id 1) where we are making the @id value and the id column equal to the current @id value 1.