(age-website) branch master updated: Fix missing column names in queries in advanced.md (#347)

[mtaha]

This is an automated email from the ASF dual-hosted git repository.

mtaha pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/age-website.git


The following commit(s) were added to refs/heads/master by this push:
     new d5cc2f89 Fix missing column names in queries in advanced.md (#347)
d5cc2f89 is described below

commit d5cc2f899828f6cafbd5318baf97d10ad5148952
Author: Alexander Quine <alx...@users.noreply.github.com>
AuthorDate: Sun Sep 7 04:30:31 2025 -0700

    Fix missing column names in queries in advanced.md (#347)
    
    * add missing column name to `SELECT`
    * more consistent capitalization of query terms
---
 docs/advanced/advanced.md | 36 +++++++++++++++++++-----------------
 1 file changed, 19 insertions(+), 17 deletions(-)

diff --git a/docs/advanced/advanced.md b/docs/advanced/advanced.md
index 9ef3ae6e..8a0ee0fc 100644
--- a/docs/advanced/advanced.md
+++ b/docs/advanced/advanced.md
@@ -8,12 +8,12 @@ Query:
 
 
 ```postgresql
-WITH graph_query as (
+WITH graph_query AS (
     SELECT *
         FROM cypher('graph_name', $$
         MATCH (n)
         RETURN n.name, n.age
-    $$) as (name agtype, age agtype)
+    $$) AS (name agtype, age agtype)
 )
 SELECT * FROM graph_query;
 ```
@@ -71,13 +71,13 @@ Query:
 
 ```postgresql
 SELECT id, 
-    graph_query.name = t.name as names_match,
-    graph_query.age = t.age as ages_match
+    graph_query.name = t.name AS names_match,
+    graph_query.age = t.age AS ages_match
 FROM schema_name.sql_person AS t
 JOIN cypher('graph_name', $$
         MATCH (n:Person)
         RETURN n.name, n.age, id(n)
-$$) as graph_query(name agtype, age agtype, id agtype)
+$$) AS graph_query(name agtype, age agtype, id agtype)
 ON t.person_id = graph_query.id
 ```
 
@@ -136,13 +136,14 @@ When writing a cypher query that is known to return one 
column and one row, the
 
 
 ```postgresql
-SELECT t.name FROM schema_name.sql_person AS t
-where t.name = (
+SELECT t.name, t.age
+FROM schema_name.sql_person AS t
+WHERE t.name = (
     SELECT a
     FROM cypher('graph_name', $$
-         MATCH (v)
+       MATCH (v)
         RETURN v.name
-    $$) as (name varchar(50))
+    $$) AS (name varchar(50))
     ORDER BY name
     LIMIT 1);
 ```
@@ -180,13 +181,14 @@ Query:
 
 
 ```postgresql
-SELECT t.name, t.age FROM schema_name.sql_person as t 
-where t.name in (
+SELECT t.name, t.age
+FROM schema_name.sql_person AS t 
+WHERE t.name IN (
     SELECT *
     FROM cypher('graph_name', $$
         MATCH (v:Person)
         RETURN v.name 
-    $$) as (a agtype));
+    $$) AS (a agtype));
 ```
 
 
@@ -235,13 +237,13 @@ Query:
 
 ```postgresql
 SELECT t.name, t.age
-FROM schema_name.sql_person as t
+FROM schema_name.sql_person AS t
 WHERE EXISTS (
     SELECT *
     FROM cypher('graph_name', $$
-         MATCH (v:Person)
+        MATCH (v:Person)
         RETURN v.name, v.age
-    $$) as (name agtype, age agtype)
+    $$) AS (name agtype, age agtype)
     WHERE name = t.name AND age = t.age
 );
 ```
@@ -287,11 +289,11 @@ SELECT graph_1.name, graph_1.age, graph_2.license_number
 FROM cypher('graph_1', $$
     MATCH (v:Person)
     RETURN v.name, v.age
-$$) as graph_1(col_1 agtype, col_2 agtype, col_3 agtype)
+$$) AS graph_1(col_1 agtype, col_2 agtype, col_3 agtype)
 JOIN cypher('graph_2', $$
     MATCH (v:Doctor)
     RETURN v.name, v.license_number
-$$) as graph_2(name agtype, license_number agtype)
+$$) AS graph_2(name agtype, license_number agtype)
 ON graph_1.name = graph_2.name
 ```