This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/incubator-age-website.git
The following commit(s) were added to refs/heads/asf-site by this push:
new f344347 deploy: e9815dd2f0da8ade70dccae4045b19b47d73c15a
f344347 is described below
commit f3443475e253600a271c7016d8dfc4396eae996e
Author: JoshInnis <[email protected]>
AuthorDate: Thu Oct 21 19:30:47 2021 +0000
deploy: e9815dd2f0da8ade70dccae4045b19b47d73c15a
---
docs/master/.buildinfo | 2 +-
docs/master/.doctrees/advanced/advanced.doctree | Bin 17156 -> 17332 bytes
.../.doctrees/advanced/advanced_overview.doctree | Bin 3665 -> 3665 bytes
docs/master/.doctrees/advanced/plpgsql.doctree | Bin 4255 -> 4203 bytes
.../.doctrees/advanced/prepared_statements.doctree | Bin 8572 -> 8572 bytes
.../.doctrees/advanced/sql_in_cypher.doctree | Bin 0 -> 5905 bytes
docs/master/.doctrees/clauses/create.doctree | Bin 20453 -> 20453 bytes
docs/master/.doctrees/clauses/delete.doctree | Bin 11208 -> 11208 bytes
docs/master/.doctrees/clauses/limit.doctree | Bin 7427 -> 7427 bytes
docs/master/.doctrees/clauses/match.doctree | Bin 25090 -> 25090 bytes
docs/master/.doctrees/clauses/order_by.doctree | Bin 15347 -> 15347 bytes
docs/master/.doctrees/clauses/remove.doctree | Bin 6630 -> 6630 bytes
docs/master/.doctrees/clauses/return.doctree | Bin 21591 -> 21591 bytes
docs/master/.doctrees/clauses/set.doctree | Bin 11952 -> 11952 bytes
docs/master/.doctrees/clauses/skip.doctree | Bin 9537 -> 9537 bytes
docs/master/.doctrees/clauses/with.doctree | Bin 11085 -> 11085 bytes
docs/master/.doctrees/environment.pickle | Bin 120855 -> 122564 bytes
.../functions/aggregate_functions.doctree | Bin 51852 -> 51852 bytes
.../.doctrees/functions/list_functions.doctree | Bin 2677 -> 2677 bytes
.../functions/logarithmic_functions.doctree | Bin 16358 -> 16358 bytes
.../.doctrees/functions/numeric_functions.doctree | Bin 22664 -> 22664 bytes
.../functions/predicate_functions.doctree | Bin 6445 -> 6445 bytes
.../.doctrees/functions/scalar_functions.doctree | Bin 56524 -> 56524 bytes
.../.doctrees/functions/string_functions.doctree | Bin 47951 -> 47951 bytes
.../functions/trigonometric_functions.doctree | Bin 34627 -> 34627 bytes
.../.doctrees/functions/user_functions.doctree | Bin 4976 -> 4976 bytes
docs/master/.doctrees/index.doctree | Bin 4090 -> 4123 bytes
docs/master/.doctrees/intro/aggregation.doctree | Bin 6801 -> 6801 bytes
docs/master/.doctrees/intro/comparability.doctree | Bin 32235 -> 32235 bytes
docs/master/.doctrees/intro/cypher.doctree | Bin 10246 -> 10246 bytes
docs/master/.doctrees/intro/graphs.doctree | Bin 11554 -> 11554 bytes
docs/master/.doctrees/intro/overview.doctree | Bin 4006 -> 4006 bytes
docs/master/.doctrees/intro/precedence.doctree | Bin 6872 -> 6872 bytes
docs/master/.doctrees/intro/setup.doctree | Bin 11024 -> 11024 bytes
docs/master/.doctrees/intro/types.doctree | Bin 81184 -> 81184 bytes
docs/master/_sources/advanced/advanced.md.txt | 4 +-
docs/master/_sources/advanced/plpgsql.md.txt | 12 +++-
docs/master/_sources/advanced/sql_in_cypher.md.txt | 48 +++++++++++++
docs/master/_sources/index.rst.txt | 2 +
docs/master/advanced/advanced.html | 17 ++---
docs/master/advanced/advanced_overview.html | 9 +--
docs/master/advanced/plpgsql.html | 25 ++++---
docs/master/advanced/prepared_statements.html | 9 +--
.../advanced/{plpgsql.html => sql_in_cypher.html} | 77 ++++++++++++++-------
docs/master/clauses/create.html | 5 +-
docs/master/clauses/delete.html | 5 +-
docs/master/clauses/limit.html | 5 +-
docs/master/clauses/match.html | 5 +-
docs/master/clauses/order_by.html | 5 +-
docs/master/clauses/remove.html | 5 +-
docs/master/clauses/return.html | 5 +-
docs/master/clauses/set.html | 5 +-
docs/master/clauses/skip.html | 5 +-
docs/master/clauses/with.html | 5 +-
docs/master/functions/aggregate_functions.html | 5 +-
docs/master/functions/list_functions.html | 5 +-
docs/master/functions/logarithmic_functions.html | 5 +-
docs/master/functions/numeric_functions.html | 5 +-
docs/master/functions/predicate_functions.html | 5 +-
docs/master/functions/scalar_functions.html | 5 +-
docs/master/functions/string_functions.html | 5 +-
docs/master/functions/trigonometric_functions.html | 5 +-
docs/master/functions/user_functions.html | 5 +-
docs/master/genindex.html | 5 +-
docs/master/index.html | 10 +--
docs/master/intro/aggregation.html | 5 +-
docs/master/intro/comparability.html | 5 +-
docs/master/intro/cypher.html | 5 +-
docs/master/intro/graphs.html | 5 +-
docs/master/intro/overview.html | 5 +-
docs/master/intro/precedence.html | 5 +-
docs/master/intro/setup.html | 5 +-
docs/master/intro/types.html | 5 +-
docs/master/objects.inv | Bin 808 -> 842 bytes
docs/master/search.html | 5 +-
docs/master/searchindex.js | 2 +-
76 files changed, 242 insertions(+), 120 deletions(-)
diff --git a/docs/master/.buildinfo b/docs/master/.buildinfo
index c0530f7..86a7ebc 100644
--- a/docs/master/.buildinfo
+++ b/docs/master/.buildinfo
@@ -1,4 +1,4 @@
# Sphinx build info version 1
# This file hashes the configuration used when building these files. When it
is not found, a full rebuild will be done.
-config: 7ad2a4ed6f0711663ca49de8b93a2fde
+config: f71e51e00e5f909d7572b07340e3f418
tags: 645f666f9bcd5a90fca523b33c5a78b7
diff --git a/docs/master/.doctrees/advanced/advanced.doctree
b/docs/master/.doctrees/advanced/advanced.doctree
index c90d047..940970c 100644
Binary files a/docs/master/.doctrees/advanced/advanced.doctree and
b/docs/master/.doctrees/advanced/advanced.doctree differ
diff --git a/docs/master/.doctrees/advanced/advanced_overview.doctree
b/docs/master/.doctrees/advanced/advanced_overview.doctree
index ff86c0e..9a6fbf7 100644
Binary files a/docs/master/.doctrees/advanced/advanced_overview.doctree and
b/docs/master/.doctrees/advanced/advanced_overview.doctree differ
diff --git a/docs/master/.doctrees/advanced/plpgsql.doctree
b/docs/master/.doctrees/advanced/plpgsql.doctree
index acc26fb..615cda6 100644
Binary files a/docs/master/.doctrees/advanced/plpgsql.doctree and
b/docs/master/.doctrees/advanced/plpgsql.doctree differ
diff --git a/docs/master/.doctrees/advanced/prepared_statements.doctree
b/docs/master/.doctrees/advanced/prepared_statements.doctree
index e14afda..f8d7c71 100644
Binary files a/docs/master/.doctrees/advanced/prepared_statements.doctree and
b/docs/master/.doctrees/advanced/prepared_statements.doctree differ
diff --git a/docs/master/.doctrees/advanced/sql_in_cypher.doctree
b/docs/master/.doctrees/advanced/sql_in_cypher.doctree
new file mode 100644
index 0000000..69d5c14
Binary files /dev/null and
b/docs/master/.doctrees/advanced/sql_in_cypher.doctree differ
diff --git a/docs/master/.doctrees/clauses/create.doctree
b/docs/master/.doctrees/clauses/create.doctree
index 35a4b7f..c21d167 100644
Binary files a/docs/master/.doctrees/clauses/create.doctree and
b/docs/master/.doctrees/clauses/create.doctree differ
diff --git a/docs/master/.doctrees/clauses/delete.doctree
b/docs/master/.doctrees/clauses/delete.doctree
index 7422b4c..1295b1e 100644
Binary files a/docs/master/.doctrees/clauses/delete.doctree and
b/docs/master/.doctrees/clauses/delete.doctree differ
diff --git a/docs/master/.doctrees/clauses/limit.doctree
b/docs/master/.doctrees/clauses/limit.doctree
index e3d5305..b3c5700 100644
Binary files a/docs/master/.doctrees/clauses/limit.doctree and
b/docs/master/.doctrees/clauses/limit.doctree differ
diff --git a/docs/master/.doctrees/clauses/match.doctree
b/docs/master/.doctrees/clauses/match.doctree
index 06c3630..6365902 100644
Binary files a/docs/master/.doctrees/clauses/match.doctree and
b/docs/master/.doctrees/clauses/match.doctree differ
diff --git a/docs/master/.doctrees/clauses/order_by.doctree
b/docs/master/.doctrees/clauses/order_by.doctree
index 3e627c8..2e87c8f 100644
Binary files a/docs/master/.doctrees/clauses/order_by.doctree and
b/docs/master/.doctrees/clauses/order_by.doctree differ
diff --git a/docs/master/.doctrees/clauses/remove.doctree
b/docs/master/.doctrees/clauses/remove.doctree
index 4f684a8..9999433 100644
Binary files a/docs/master/.doctrees/clauses/remove.doctree and
b/docs/master/.doctrees/clauses/remove.doctree differ
diff --git a/docs/master/.doctrees/clauses/return.doctree
b/docs/master/.doctrees/clauses/return.doctree
index d46aade..026ca7f 100644
Binary files a/docs/master/.doctrees/clauses/return.doctree and
b/docs/master/.doctrees/clauses/return.doctree differ
diff --git a/docs/master/.doctrees/clauses/set.doctree
b/docs/master/.doctrees/clauses/set.doctree
index 4b05f31..9234775 100644
Binary files a/docs/master/.doctrees/clauses/set.doctree and
b/docs/master/.doctrees/clauses/set.doctree differ
diff --git a/docs/master/.doctrees/clauses/skip.doctree
b/docs/master/.doctrees/clauses/skip.doctree
index be30f38..c009288 100644
Binary files a/docs/master/.doctrees/clauses/skip.doctree and
b/docs/master/.doctrees/clauses/skip.doctree differ
diff --git a/docs/master/.doctrees/clauses/with.doctree
b/docs/master/.doctrees/clauses/with.doctree
index 9d614c5..a813ef3 100644
Binary files a/docs/master/.doctrees/clauses/with.doctree and
b/docs/master/.doctrees/clauses/with.doctree differ
diff --git a/docs/master/.doctrees/environment.pickle
b/docs/master/.doctrees/environment.pickle
index fa79941..5f9e618 100644
Binary files a/docs/master/.doctrees/environment.pickle and
b/docs/master/.doctrees/environment.pickle differ
diff --git a/docs/master/.doctrees/functions/aggregate_functions.doctree
b/docs/master/.doctrees/functions/aggregate_functions.doctree
index 964a2d8..3fb76fe 100644
Binary files a/docs/master/.doctrees/functions/aggregate_functions.doctree and
b/docs/master/.doctrees/functions/aggregate_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/list_functions.doctree
b/docs/master/.doctrees/functions/list_functions.doctree
index 6551247..5ba778c 100644
Binary files a/docs/master/.doctrees/functions/list_functions.doctree and
b/docs/master/.doctrees/functions/list_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/logarithmic_functions.doctree
b/docs/master/.doctrees/functions/logarithmic_functions.doctree
index dae1300..e6fd078 100644
Binary files a/docs/master/.doctrees/functions/logarithmic_functions.doctree
and b/docs/master/.doctrees/functions/logarithmic_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/numeric_functions.doctree
b/docs/master/.doctrees/functions/numeric_functions.doctree
index aaf5865..ca494a8 100644
Binary files a/docs/master/.doctrees/functions/numeric_functions.doctree and
b/docs/master/.doctrees/functions/numeric_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/predicate_functions.doctree
b/docs/master/.doctrees/functions/predicate_functions.doctree
index 4789254..ea6a4eb 100644
Binary files a/docs/master/.doctrees/functions/predicate_functions.doctree and
b/docs/master/.doctrees/functions/predicate_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/scalar_functions.doctree
b/docs/master/.doctrees/functions/scalar_functions.doctree
index 54b32bd..5464222 100644
Binary files a/docs/master/.doctrees/functions/scalar_functions.doctree and
b/docs/master/.doctrees/functions/scalar_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/string_functions.doctree
b/docs/master/.doctrees/functions/string_functions.doctree
index ee26638..751b289 100644
Binary files a/docs/master/.doctrees/functions/string_functions.doctree and
b/docs/master/.doctrees/functions/string_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/trigonometric_functions.doctree
b/docs/master/.doctrees/functions/trigonometric_functions.doctree
index 60d1ac3..8319e06 100644
Binary files a/docs/master/.doctrees/functions/trigonometric_functions.doctree
and b/docs/master/.doctrees/functions/trigonometric_functions.doctree differ
diff --git a/docs/master/.doctrees/functions/user_functions.doctree
b/docs/master/.doctrees/functions/user_functions.doctree
index ad0de16..13490ec 100644
Binary files a/docs/master/.doctrees/functions/user_functions.doctree and
b/docs/master/.doctrees/functions/user_functions.doctree differ
diff --git a/docs/master/.doctrees/index.doctree
b/docs/master/.doctrees/index.doctree
index e283d1b..5b092fe 100644
Binary files a/docs/master/.doctrees/index.doctree and
b/docs/master/.doctrees/index.doctree differ
diff --git a/docs/master/.doctrees/intro/aggregation.doctree
b/docs/master/.doctrees/intro/aggregation.doctree
index 6d25ab0..243d025 100644
Binary files a/docs/master/.doctrees/intro/aggregation.doctree and
b/docs/master/.doctrees/intro/aggregation.doctree differ
diff --git a/docs/master/.doctrees/intro/comparability.doctree
b/docs/master/.doctrees/intro/comparability.doctree
index c6743dd..c3fabc7 100644
Binary files a/docs/master/.doctrees/intro/comparability.doctree and
b/docs/master/.doctrees/intro/comparability.doctree differ
diff --git a/docs/master/.doctrees/intro/cypher.doctree
b/docs/master/.doctrees/intro/cypher.doctree
index 770933f..0993bbd 100644
Binary files a/docs/master/.doctrees/intro/cypher.doctree and
b/docs/master/.doctrees/intro/cypher.doctree differ
diff --git a/docs/master/.doctrees/intro/graphs.doctree
b/docs/master/.doctrees/intro/graphs.doctree
index 917d738..ecda36f 100644
Binary files a/docs/master/.doctrees/intro/graphs.doctree and
b/docs/master/.doctrees/intro/graphs.doctree differ
diff --git a/docs/master/.doctrees/intro/overview.doctree
b/docs/master/.doctrees/intro/overview.doctree
index c69fb01..e16d055 100644
Binary files a/docs/master/.doctrees/intro/overview.doctree and
b/docs/master/.doctrees/intro/overview.doctree differ
diff --git a/docs/master/.doctrees/intro/precedence.doctree
b/docs/master/.doctrees/intro/precedence.doctree
index 42667be..2f59879 100644
Binary files a/docs/master/.doctrees/intro/precedence.doctree and
b/docs/master/.doctrees/intro/precedence.doctree differ
diff --git a/docs/master/.doctrees/intro/setup.doctree
b/docs/master/.doctrees/intro/setup.doctree
index f1728b0..d090aea 100644
Binary files a/docs/master/.doctrees/intro/setup.doctree and
b/docs/master/.doctrees/intro/setup.doctree differ
diff --git a/docs/master/.doctrees/intro/types.doctree
b/docs/master/.doctrees/intro/types.doctree
index 4c31638..15eaf9d 100644
Binary files a/docs/master/.doctrees/intro/types.doctree and
b/docs/master/.doctrees/intro/types.doctree differ
diff --git a/docs/master/_sources/advanced/advanced.md.txt
b/docs/master/_sources/advanced/advanced.md.txt
index 56c5672..0c78bd2 100644
--- a/docs/master/_sources/advanced/advanced.md.txt
+++ b/docs/master/_sources/advanced/advanced.md.txt
@@ -1,6 +1,6 @@
-# CTE Clause
+# Using Cypher in a CTE Expression
There are no restrictions to using Cypher with CTEs.
@@ -55,7 +55,7 @@ Results:
-# Join Clause
+# Using Cypher in a Join expression
A Cypher query can be part of a JOIN clause.
diff --git a/docs/master/_sources/advanced/plpgsql.md.txt
b/docs/master/_sources/advanced/plpgsql.md.txt
index e018ad5..f486669 100644
--- a/docs/master/_sources/advanced/plpgsql.md.txt
+++ b/docs/master/_sources/advanced/plpgsql.md.txt
@@ -2,11 +2,17 @@
Cypher commands can be run in
[PL/pgSQL](https://www.postgresql.org/docs/11/plpgsql-overview.html) functions
without restriction.
-## Basic PL/pgSQL
+## Void PL/pgSQL
-## Returning scalar data
-## Returning SRF data
+
+
+
+## Scalar Function
+
+## SRF Function
## Dynamic Cypher
+
+
diff --git a/docs/master/_sources/advanced/sql_in_cypher.md.txt
b/docs/master/_sources/advanced/sql_in_cypher.md.txt
new file mode 100644
index 0000000..8a94fa7
--- /dev/null
+++ b/docs/master/_sources/advanced/sql_in_cypher.md.txt
@@ -0,0 +1,48 @@
+# SQL In Cypher
+
+AGE does not support SQL being directly written in Cypher. However with [user
defined functions](../functions/user_functions#) you can write sql queries and
call them in a cypher command.
+
+
+```
+Developer's Note:
+
+Void and Scalar-Value functions only. Set returning functions are not
currently supported.
+```
+
+
+## Create Function
+```
+CREATE OR REPLACE FUNCTION public.get_event_year(name agtype) RETURNS agtype
AS $$
+ SELECT year::agtype
+ FROM history AS h
+ WHERE h.event_name = name::text
+ LIMIT 1;
+$$ LANGUAGE sql;
+```
+
+## Query
+```
+SELECT * FROM cypher('graph_name', $$
+ MATCH (e:event)
+ WHERE e.year < public.get_event_year(e.name)
+ RETURN n.name
+$$) as (n agtype);
+
+```
+
+Results
+<table>
+ <tr>
+ <td><strong>name</strong>
+ </td>
+ </tr>
+ <tr>
+ <td>"Apache Con 2021"
+ </td>
+ </tr>
+ <tr>
+ <td colspan="1" >1 row
+ </td>
+ </tr>
+</table>
+
diff --git a/docs/master/_sources/index.rst.txt
b/docs/master/_sources/index.rst.txt
index 1d8b7eb..02bd3de 100644
--- a/docs/master/_sources/index.rst.txt
+++ b/docs/master/_sources/index.rst.txt
@@ -52,3 +52,5 @@ Apache AGE's documentation
advanced/advanced
advanced/prepared_statements
advanced/plpgsql
+ advanced/sql_in_cypher
+
diff --git a/docs/master/advanced/advanced.html
b/docs/master/advanced/advanced.html
index 0e4dae2..2cde3b2 100644
--- a/docs/master/advanced/advanced.html
+++ b/docs/master/advanced/advanced.html
@@ -7,7 +7,7 @@
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
- <title>CTE Clause — Apache AGE master documentation</title>
+ <title>Using Cypher in a CTE Expression — Apache AGE master
documentation</title>
@@ -132,8 +132,8 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul class="current">
<li class="toctree-l1"><a class="reference internal"
href="advanced_overview.html">Overview</a></li>
-<li class="toctree-l1 current"><a class="current reference internal"
href="#">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal" href="#join-clause">Join
Clause</a></li>
+<li class="toctree-l1 current"><a class="current reference internal"
href="#">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="#using-cypher-in-a-join-expression">Using Cypher in a Join
expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="#cypher-in-sql-expressions">Cypher in SQL expressions</a><ul>
<li class="toctree-l2"><a class="reference internal"
href="#using-cypher-with">Using Cypher with ‘=’</a></li>
<li class="toctree-l2"><a class="reference internal"
href="#working-with-postgres-s-in-clause">Working with Postgres’s IN
Clause</a></li>
@@ -143,6 +143,7 @@
</li>
<li class="toctree-l1"><a class="reference internal"
href="prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
@@ -191,7 +192,7 @@
<li><a href="../index.html" class="icon icon-home"></a> »</li>
- <li>CTE Clause</li>
+ <li>Using Cypher in a CTE Expression</li>
<li class="wy-breadcrumbs-aside">
@@ -212,8 +213,8 @@
<div role="main" class="document" itemscope="itemscope"
itemtype="http://schema.org/Article";>
<div itemprop="articleBody">
- <div class="tex2jax_ignore mathjax_ignore section" id="cte-clause">
-<h1>CTE Clause<a class="headerlink" href="#cte-clause" title="Permalink to
this headline">¶</a></h1>
+ <div class="tex2jax_ignore mathjax_ignore section"
id="using-cypher-in-a-cte-expression">
+<h1>Using Cypher in a CTE Expression<a class="headerlink"
href="#using-cypher-in-a-cte-expression" title="Permalink to this
headline">¶</a></h1>
<p>There are no restrictions to using Cypher with CTEs.</p>
<p>Query:</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>WITH graph_query as (
@@ -258,8 +259,8 @@ SELECT * FROM graph_query;
</tr>
</table>
</div>
-<div class="tex2jax_ignore mathjax_ignore section" id="join-clause">
-<h1>Join Clause<a class="headerlink" href="#join-clause" title="Permalink to
this headline">¶</a></h1>
+<div class="tex2jax_ignore mathjax_ignore section"
id="using-cypher-in-a-join-expression">
+<h1>Using Cypher in a Join expression<a class="headerlink"
href="#using-cypher-in-a-join-expression" title="Permalink to this
headline">¶</a></h1>
<p>A Cypher query can be part of a JOIN clause.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">Developers</span> <span
class="n">Note</span>
<span class="n">Cypher</span> <span class="n">queries</span> <span
class="n">using</span> <span class="n">the</span> <span
class="n">CREATE</span><span class="p">,</span> <span class="n">SET</span><span
class="p">,</span> <span class="n">REMOVE</span> <span class="n">clauses</span>
<span class="n">cannot</span> <span class="n">be</span> <span
class="n">used</span> <span class="ow">in</span> <span class="n">sql</span>
<span class="n">queries</span> <span class="k">with</span> <span class= [...]
diff --git a/docs/master/advanced/advanced_overview.html
b/docs/master/advanced/advanced_overview.html
index 20ee954..e7b1893 100644
--- a/docs/master/advanced/advanced_overview.html
+++ b/docs/master/advanced/advanced_overview.html
@@ -44,7 +44,7 @@
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
- <link rel="next" title="CTE Clause" href="advanced.html" />
+ <link rel="next" title="Using Cypher in a CTE Expression"
href="advanced.html" />
<link rel="prev" title="User defined functions"
href="../functions/user_functions.html" />
</head>
@@ -132,11 +132,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul class="current">
<li class="toctree-l1 current"><a class="current reference internal"
href="#">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal" href="advanced.html">CTE
Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced.html#using-cypher-in-a-join-expression">Using Cypher in a Join
expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
@@ -217,7 +218,7 @@
</div>
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
- <a href="advanced.html" class="btn btn-neutral float-right" title="CTE
Clause" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"
aria-hidden="true"></span></a>
+ <a href="advanced.html" class="btn btn-neutral float-right"
title="Using Cypher in a CTE Expression" accesskey="n" rel="next">Next <span
class="fa fa-arrow-circle-right" aria-hidden="true"></span></a>
<a href="../functions/user_functions.html" class="btn btn-neutral
float-left" title="User defined functions" accesskey="p" rel="prev"><span
class="fa fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
</div>
diff --git a/docs/master/advanced/plpgsql.html
b/docs/master/advanced/plpgsql.html
index 186ef3c..6cf6766 100644
--- a/docs/master/advanced/plpgsql.html
+++ b/docs/master/advanced/plpgsql.html
@@ -44,6 +44,7 @@
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
+ <link rel="next" title="SQL In Cypher" href="sql_in_cypher.html" />
<link rel="prev" title="Prepared Statements"
href="prepared_statements.html" />
</head>
@@ -131,17 +132,18 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul class="current">
<li class="toctree-l1"><a class="reference internal"
href="advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal" href="advanced.html">CTE
Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced.html#using-cypher-in-a-join-expression">Using Cypher in a Join
expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1 current"><a class="current reference internal"
href="#">PL/pgSQL Functions</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="#basic-pl-pgsql">Basic PL/pgSQL</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="#returning-scalar-data">Returning scalar data</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="#returning-srf-data">Returning SRF data</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="#void-pl-pgsql">Void PL/pgSQL</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="#scalar-function">Scalar Function</a></li>
+<li class="toctree-l2"><a class="reference internal" href="#srf-function">SRF
Function</a></li>
<li class="toctree-l2"><a class="reference internal"
href="#dynamic-cypher">Dynamic Cypher</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal"
href="sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
@@ -214,14 +216,14 @@
<div class="tex2jax_ignore mathjax_ignore section" id="pl-pgsql-functions">
<h1>PL/pgSQL Functions<a class="headerlink" href="#pl-pgsql-functions"
title="Permalink to this headline">¶</a></h1>
<p>Cypher commands can be run in <a class="reference external"
href="https://www.postgresql.org/docs/11/plpgsql-overview.html";>PL/pgSQL</a>
functions without restriction.</p>
-<div class="section" id="basic-pl-pgsql">
-<h2>Basic PL/pgSQL<a class="headerlink" href="#basic-pl-pgsql"
title="Permalink to this headline">¶</a></h2>
+<div class="section" id="void-pl-pgsql">
+<h2>Void PL/pgSQL<a class="headerlink" href="#void-pl-pgsql" title="Permalink
to this headline">¶</a></h2>
</div>
-<div class="section" id="returning-scalar-data">
-<h2>Returning scalar data<a class="headerlink" href="#returning-scalar-data"
title="Permalink to this headline">¶</a></h2>
+<div class="section" id="scalar-function">
+<h2>Scalar Function<a class="headerlink" href="#scalar-function"
title="Permalink to this headline">¶</a></h2>
</div>
-<div class="section" id="returning-srf-data">
-<h2>Returning SRF data<a class="headerlink" href="#returning-srf-data"
title="Permalink to this headline">¶</a></h2>
+<div class="section" id="srf-function">
+<h2>SRF Function<a class="headerlink" href="#srf-function" title="Permalink to
this headline">¶</a></h2>
</div>
<div class="section" id="dynamic-cypher">
<h2>Dynamic Cypher<a class="headerlink" href="#dynamic-cypher"
title="Permalink to this headline">¶</a></h2>
@@ -234,6 +236,7 @@
</div>
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
+ <a href="sql_in_cypher.html" class="btn btn-neutral float-right"
title="SQL In Cypher" accesskey="n" rel="next">Next <span class="fa
fa-arrow-circle-right" aria-hidden="true"></span></a>
<a href="prepared_statements.html" class="btn btn-neutral float-left"
title="Prepared Statements" accesskey="p" rel="prev"><span class="fa
fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
</div>
diff --git a/docs/master/advanced/prepared_statements.html
b/docs/master/advanced/prepared_statements.html
index 28db9ca..582d2c5 100644
--- a/docs/master/advanced/prepared_statements.html
+++ b/docs/master/advanced/prepared_statements.html
@@ -45,7 +45,7 @@
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
<link rel="next" title="PL/pgSQL Functions" href="plpgsql.html" />
- <link rel="prev" title="CTE Clause" href="advanced.html" />
+ <link rel="prev" title="Using Cypher in a CTE Expression"
href="advanced.html" />
</head>
<body class="wy-body-for-nav">
@@ -132,8 +132,8 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul class="current">
<li class="toctree-l1"><a class="reference internal"
href="advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal" href="advanced.html">CTE
Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced.html#using-cypher-in-a-join-expression">Using Cypher in a Join
expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1 current"><a class="current reference internal"
href="#">Prepared Statements</a><ul>
<li class="toctree-l2"><a class="reference internal"
href="#cypher-parameter-format">Cypher Parameter Format</a></li>
@@ -142,6 +142,7 @@
</ul>
</li>
<li class="toctree-l1"><a class="reference internal"
href="plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
@@ -249,7 +250,7 @@ AS (v agtype);
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
<a href="plpgsql.html" class="btn btn-neutral float-right"
title="PL/pgSQL Functions" accesskey="n" rel="next">Next <span class="fa
fa-arrow-circle-right" aria-hidden="true"></span></a>
- <a href="advanced.html" class="btn btn-neutral float-left" title="CTE
Clause" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"
aria-hidden="true"></span> Previous</a>
+ <a href="advanced.html" class="btn btn-neutral float-left"
title="Using Cypher in a CTE Expression" accesskey="p" rel="prev"><span
class="fa fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
</div>
<hr/>
diff --git a/docs/master/advanced/plpgsql.html
b/docs/master/advanced/sql_in_cypher.html
similarity index 74%
copy from docs/master/advanced/plpgsql.html
copy to docs/master/advanced/sql_in_cypher.html
index 186ef3c..35fb570 100644
--- a/docs/master/advanced/plpgsql.html
+++ b/docs/master/advanced/sql_in_cypher.html
@@ -7,7 +7,7 @@
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
- <title>PL/pgSQL Functions — Apache AGE master documentation</title>
+ <title>SQL In Cypher — Apache AGE master documentation</title>
@@ -44,7 +44,7 @@
<link rel="index" title="Index" href="../genindex.html" />
<link rel="search" title="Search" href="../search.html" />
- <link rel="prev" title="Prepared Statements"
href="prepared_statements.html" />
+ <link rel="prev" title="PL/pgSQL Functions" href="plpgsql.html" />
</head>
<body class="wy-body-for-nav">
@@ -131,15 +131,14 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul class="current">
<li class="toctree-l1"><a class="reference internal"
href="advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal" href="advanced.html">CTE
Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced.html#using-cypher-in-a-join-expression">Using Cypher in a Join
expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="prepared_statements.html">Prepared Statements</a></li>
-<li class="toctree-l1 current"><a class="current reference internal"
href="#">PL/pgSQL Functions</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="#basic-pl-pgsql">Basic PL/pgSQL</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="#returning-scalar-data">Returning scalar data</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="#returning-srf-data">Returning SRF data</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="#dynamic-cypher">Dynamic Cypher</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1 current"><a class="current reference internal"
href="#">SQL In Cypher</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="#create-function">Create Function</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="#query">Query</a></li>
</ul>
</li>
</ul>
@@ -190,14 +189,14 @@
<li><a href="../index.html" class="icon icon-home"></a> »</li>
- <li>PL/pgSQL Functions</li>
+ <li>SQL In Cypher</li>
<li class="wy-breadcrumbs-aside">
- <a
href="https://github.com/apache/incubator-age-website/blob/master/docs/advanced/plpgsql.md";
class="fa fa-github"> Edit on GitHub</a>
+ <a
href="https://github.com/apache/incubator-age-website/blob/master/docs/advanced/sql_in_cypher.md";
class="fa fa-github"> Edit on GitHub</a>
@@ -211,20 +210,50 @@
<div role="main" class="document" itemscope="itemscope"
itemtype="http://schema.org/Article";>
<div itemprop="articleBody">
- <div class="tex2jax_ignore mathjax_ignore section" id="pl-pgsql-functions">
-<h1>PL/pgSQL Functions<a class="headerlink" href="#pl-pgsql-functions"
title="Permalink to this headline">¶</a></h1>
-<p>Cypher commands can be run in <a class="reference external"
href="https://www.postgresql.org/docs/11/plpgsql-overview.html";>PL/pgSQL</a>
functions without restriction.</p>
-<div class="section" id="basic-pl-pgsql">
-<h2>Basic PL/pgSQL<a class="headerlink" href="#basic-pl-pgsql"
title="Permalink to this headline">¶</a></h2>
+ <div class="tex2jax_ignore mathjax_ignore section" id="sql-in-cypher">
+<h1>SQL In Cypher<a class="headerlink" href="#sql-in-cypher" title="Permalink
to this headline">¶</a></h1>
+<p>AGE does not support SQL being directly written in Cypher. However with
<span class="xref myst">user defined functions</span> you can write sql queries
and call them in a cypher command.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">Developer</span><span
class="s1">'s Note:</span>
+
+<span class="n">Void</span> <span class="ow">and</span> <span
class="n">Scalar</span><span class="o">-</span><span class="n">Value</span>
<span class="n">functions</span> <span class="n">only</span><span
class="o">.</span> <span class="n">Set</span> <span class="n">returning</span>
<span class="n">functions</span> <span class="n">are</span> <span
class="ow">not</span> <span class="n">currently</span> <span
class="n">supported</span><span class="o">.</span>
+</pre></div>
+</div>
+<div class="section" id="create-function">
+<h2>Create Function<a class="headerlink" href="#create-function"
title="Permalink to this headline">¶</a></h2>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>CREATE OR REPLACE FUNCTION
public.get_event_year(name agtype) RETURNS agtype AS $$
+ SELECT year::agtype
+ FROM history AS h
+ WHERE h.event_name = name::text
+ LIMIT 1;
+$$ LANGUAGE sql;
+</pre></div>
</div>
-<div class="section" id="returning-scalar-data">
-<h2>Returning scalar data<a class="headerlink" href="#returning-scalar-data"
title="Permalink to this headline">¶</a></h2>
</div>
-<div class="section" id="returning-srf-data">
-<h2>Returning SRF data<a class="headerlink" href="#returning-srf-data"
title="Permalink to this headline">¶</a></h2>
+<div class="section" id="query">
+<h2>Query<a class="headerlink" href="#query" title="Permalink to this
headline">¶</a></h2>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>SELECT * FROM cypher('graph_name',
$$
+ MATCH (e:event)
+ WHERE e.year < public.get_event_year(e.name)
+ RETURN n.name
+$$) as (n agtype);
+
+</pre></div>
</div>
-<div class="section" id="dynamic-cypher">
-<h2>Dynamic Cypher<a class="headerlink" href="#dynamic-cypher"
title="Permalink to this headline">¶</a></h2>
+<p>Results</p>
+<table>
+ <tr>
+ <td><strong>name</strong>
+ </td>
+ </tr>
+ <tr>
+ <td>"Apache Con 2021"
+ </td>
+ </tr>
+ <tr>
+ <td colspan="1" >1 row
+ </td>
+ </tr>
+</table>
</div>
</div>
@@ -234,7 +263,7 @@
</div>
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer
navigation">
- <a href="prepared_statements.html" class="btn btn-neutral float-left"
title="Prepared Statements" accesskey="p" rel="prev"><span class="fa
fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
+ <a href="plpgsql.html" class="btn btn-neutral float-left"
title="PL/pgSQL Functions" accesskey="p" rel="prev"><span class="fa
fa-arrow-circle-left" aria-hidden="true"></span> Previous</a>
</div>
<hr/>
@@ -271,7 +300,7 @@
<div class="rst-other-versions">
<dl>
<dt>Versions</dt>
- <dd><a href="plpgsql.html">master</a></dd>
+ <dd><a href="sql_in_cypher.html">master</a></dd>
</dl>
</div>
</div>
diff --git a/docs/master/clauses/create.html b/docs/master/clauses/create.html
index b16e95a..ceb2678 100644
--- a/docs/master/clauses/create.html
+++ b/docs/master/clauses/create.html
@@ -143,11 +143,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/clauses/delete.html b/docs/master/clauses/delete.html
index 041803b..03097cd 100644
--- a/docs/master/clauses/delete.html
+++ b/docs/master/clauses/delete.html
@@ -140,11 +140,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/clauses/limit.html b/docs/master/clauses/limit.html
index 8d8b6ef..ae0679a 100644
--- a/docs/master/clauses/limit.html
+++ b/docs/master/clauses/limit.html
@@ -137,11 +137,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/clauses/match.html b/docs/master/clauses/match.html
index 21830b8..067175b 100644
--- a/docs/master/clauses/match.html
+++ b/docs/master/clauses/match.html
@@ -149,11 +149,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/clauses/order_by.html
b/docs/master/clauses/order_by.html
index 2ba8630..2633f54 100644
--- a/docs/master/clauses/order_by.html
+++ b/docs/master/clauses/order_by.html
@@ -139,11 +139,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/clauses/remove.html b/docs/master/clauses/remove.html
index 46a8c2d..324a7c8 100644
--- a/docs/master/clauses/remove.html
+++ b/docs/master/clauses/remove.html
@@ -136,11 +136,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/clauses/return.html b/docs/master/clauses/return.html
index abf3fce..711013e 100644
--- a/docs/master/clauses/return.html
+++ b/docs/master/clauses/return.html
@@ -143,11 +143,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/clauses/set.html b/docs/master/clauses/set.html
index 8785db3..6230c6e 100644
--- a/docs/master/clauses/set.html
+++ b/docs/master/clauses/set.html
@@ -139,11 +139,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/clauses/skip.html b/docs/master/clauses/skip.html
index 8bf87e0..9d53422 100644
--- a/docs/master/clauses/skip.html
+++ b/docs/master/clauses/skip.html
@@ -138,11 +138,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/clauses/with.html b/docs/master/clauses/with.html
index 1993a7e..72d9a95 100644
--- a/docs/master/clauses/with.html
+++ b/docs/master/clauses/with.html
@@ -138,11 +138,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/functions/aggregate_functions.html
b/docs/master/functions/aggregate_functions.html
index e3ae96c..b44e38c 100644
--- a/docs/master/functions/aggregate_functions.html
+++ b/docs/master/functions/aggregate_functions.html
@@ -150,11 +150,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/functions/list_functions.html
b/docs/master/functions/list_functions.html
index 469e575..8070537 100644
--- a/docs/master/functions/list_functions.html
+++ b/docs/master/functions/list_functions.html
@@ -132,11 +132,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/functions/logarithmic_functions.html
b/docs/master/functions/logarithmic_functions.html
index 9bc2fb9..0225feb 100644
--- a/docs/master/functions/logarithmic_functions.html
+++ b/docs/master/functions/logarithmic_functions.html
@@ -139,11 +139,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/functions/numeric_functions.html
b/docs/master/functions/numeric_functions.html
index ad8e5b7..c599c14 100644
--- a/docs/master/functions/numeric_functions.html
+++ b/docs/master/functions/numeric_functions.html
@@ -140,11 +140,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/functions/predicate_functions.html
b/docs/master/functions/predicate_functions.html
index c684c19..941fccd 100644
--- a/docs/master/functions/predicate_functions.html
+++ b/docs/master/functions/predicate_functions.html
@@ -136,11 +136,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/functions/scalar_functions.html
b/docs/master/functions/scalar_functions.html
index 6fdf201..380e63c 100644
--- a/docs/master/functions/scalar_functions.html
+++ b/docs/master/functions/scalar_functions.html
@@ -150,11 +150,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/functions/string_functions.html
b/docs/master/functions/string_functions.html
index c4cef6f..6ac4da6 100644
--- a/docs/master/functions/string_functions.html
+++ b/docs/master/functions/string_functions.html
@@ -146,11 +146,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/functions/trigonometric_functions.html
b/docs/master/functions/trigonometric_functions.html
index 0aced29..bd01e1c 100644
--- a/docs/master/functions/trigonometric_functions.html
+++ b/docs/master/functions/trigonometric_functions.html
@@ -144,11 +144,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/functions/user_functions.html
b/docs/master/functions/user_functions.html
index 0113a4e..844a9d4 100644
--- a/docs/master/functions/user_functions.html
+++ b/docs/master/functions/user_functions.html
@@ -132,11 +132,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/genindex.html b/docs/master/genindex.html
index 4aa77df..c340fd0 100644
--- a/docs/master/genindex.html
+++ b/docs/master/genindex.html
@@ -130,11 +130,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher in
a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/index.html b/docs/master/index.html
index 4f6b7ea..e03351f 100644
--- a/docs/master/index.html
+++ b/docs/master/index.html
@@ -131,11 +131,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher in
a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
@@ -253,11 +254,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher in
a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
</div>
</div>
diff --git a/docs/master/intro/aggregation.html
b/docs/master/intro/aggregation.html
index 62eb539..35ed6ac 100644
--- a/docs/master/intro/aggregation.html
+++ b/docs/master/intro/aggregation.html
@@ -132,11 +132,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/intro/comparability.html
b/docs/master/intro/comparability.html
index 7eb56d6..b5ac997 100644
--- a/docs/master/intro/comparability.html
+++ b/docs/master/intro/comparability.html
@@ -146,11 +146,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/intro/cypher.html b/docs/master/intro/cypher.html
index aa80dde..7f45817 100644
--- a/docs/master/intro/cypher.html
+++ b/docs/master/intro/cypher.html
@@ -137,11 +137,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/intro/graphs.html b/docs/master/intro/graphs.html
index cba5ce1..2fa3945 100644
--- a/docs/master/intro/graphs.html
+++ b/docs/master/intro/graphs.html
@@ -143,11 +143,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/intro/overview.html b/docs/master/intro/overview.html
index 472fa08..b9f42b8 100644
--- a/docs/master/intro/overview.html
+++ b/docs/master/intro/overview.html
@@ -132,11 +132,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/intro/precedence.html
b/docs/master/intro/precedence.html
index 34610e3..1a52232 100644
--- a/docs/master/intro/precedence.html
+++ b/docs/master/intro/precedence.html
@@ -132,11 +132,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/intro/setup.html b/docs/master/intro/setup.html
index a59a7c4..0c7fca6 100644
--- a/docs/master/intro/setup.html
+++ b/docs/master/intro/setup.html
@@ -151,11 +151,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/intro/types.html b/docs/master/intro/types.html
index 1a0e3a5..56e23c0 100644
--- a/docs/master/intro/types.html
+++ b/docs/master/intro/types.html
@@ -192,11 +192,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher
in a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="../advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="../advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/objects.inv b/docs/master/objects.inv
index 3fc7ae3..676e8e0 100644
Binary files a/docs/master/objects.inv and b/docs/master/objects.inv differ
diff --git a/docs/master/search.html b/docs/master/search.html
index 7b2210a..bf62d8e 100644
--- a/docs/master/search.html
+++ b/docs/master/search.html
@@ -133,11 +133,12 @@
<p class="caption" role="heading"><span class="caption-text">AGE Beyond
Cypher</span></p>
<ul>
<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced_overview.html">Overview</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html">CTE Clause</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#join-clause">Join Clause</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html">Using Cypher in a CTE Expression</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#using-cypher-in-a-join-expression">Using Cypher in
a Join expression</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/advanced.html#cypher-in-sql-expressions">Cypher in SQL
expressions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/prepared_statements.html">Prepared Statements</a></li>
<li class="toctree-l1"><a class="reference internal"
href="advanced/plpgsql.html">PL/pgSQL Functions</a></li>
+<li class="toctree-l1"><a class="reference internal"
href="advanced/sql_in_cypher.html">SQL In Cypher</a></li>
</ul>
diff --git a/docs/master/searchindex.js b/docs/master/searchindex.js
index 7b54fac..ad16b37 100644
--- a/docs/master/searchindex.js
+++ b/docs/master/searchindex.js
@@ -1 +1 @@
-Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","clauses/create","clauses/delete","clauses/limit","clauses/match","clauses/order_by","clauses/remove","clauses/return","clauses/set","clauses/skip","clauses/with","functions/aggregate_functions","functions/list_functions","functions/logarithmic_functions","functions/numeric_functions","functions/predicate_functions","functions/scalar_functions","functions/string_f
[...]
\ No newline at end of file
+Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","advanced/sql_in_cypher","clauses/create","clauses/delete","clauses/limit","clauses/match","clauses/order_by","clauses/remove","clauses/return","clauses/set","clauses/skip","clauses/with","functions/aggregate_functions","functions/list_functions","functions/logarithmic_functions","functions/numeric_functions","functions/predicate_functions","functions/scalar_funct
[...]
\ No newline at end of file
