Description of important clauses in SQL and Apache age query format part 2

In this blog we will discuss some of the important clauses in Apache age here. For part 1 you can visit here

Match:

The MATCH clause allows you to specify the patterns Cypher will search for in the database.
Cypher:

SELECT * FROM cypher('graph_name', $$
MATCH (v)
RETURN v
$$) as (v agtype);

Above query will return all the vertices in the graph.

Return:

Return statement returns a node
Cypher:

SELECT *
FROM cypher('graph_name', $$
    MATCH (n {name: 'B'})
    RETURN n
$$) as (n agtype);

Above query will return node n.

Order by:

Order by is used for sorting of output on basis of properties of the output.
Cypher:

SELECT *
FROM cypher('graph_name', $$
    MATCH (n)
    WITH n.name as name, n.age as age
    ORDER BY n.name
    RETURN name, age
$$) as (name agtype, age agtype);

The query returns the nodes sorted by the name.

Limit:

Limit is used to constraint the number of output records.
Cypher:

SELECT * 
FROM cypher('graph_name', $$
    MATCH (n)RETURN n.name
    ORDER BY n.name
    LIMIT 3
$$) as (names agtype);

The query returns the name of first 3 nodes.

Create:

Create clause is used to create graph vertices and edges.
Cypher for creating a vertex:

SELECT * 
FROM cypher('graph_name', $$
    CREATE (n)
$$) as (v agtype);

Above query will return nothing.

Cypher for creating an edge between 2 nodes:

SELECT * 
FROM cypher('graph_name', $$
    MATCH (a:Person), (b:Person)
    WHERE a.name = 'Node A' AND b.name = 'Node B'
    CREATE (a)-[e:RELTYPE]->(b)
    RETURN e
$$) as (e agtype);

Above query will return the created edge.

Delete:

The delete clause is used to delete the graph and vertices. You cannot delete a node without also deleting edges that start or end on said vertex. Either explicitly delete the vertices or use DETACH DELETE.
Cypher:

SELECT * 
FROM cypher('graph_name', $$
    MATCH (v:Useless)
    DELETE v
$$) as (v agtype);

Above query will delete the selected vertex.

Remove

Remove and delete are completely different clauses. Remove is used to remove properties from vertex and edges.
Cypher:

SELECT * 
FROM cypher('graph_name', $$
    MATCH (andres {name: 'Andres'})
    REMOVE andres.age
    RETURN andres
$$) as (andres agtype);

The returned node has no age property in it.
References:

1. https://age.apache.org