module Clear::SQL::Query::CTE
Overview
Allow usage of Common Table Expressions (CTE) in the query building
Direct including types
Defined in:
clear/sql/query/cte.crInstance Method Summary
-
#cte : Hash(String, CTEAuthorized)
List the current CTE of the query.
-
#with_cte(name, request : CTEAuthorized)
Add a CTE to the query.
-
#with_cte(tuple : NamedTuple)
Add a CTE to the query.
Instance Method Detail
def cte : Hash(String, CTEAuthorized)
#
List the current CTE of the query. The key is the name of the CTE, while the value is the fragment (string or Sub-select)
def with_cte(name, request : CTEAuthorized)
#
Add a CTE to the query.
Clear::SQL.select.with_cte("full_year",
"SELECT DATE(date)"
"FROM generate_series(NOW() - INTERVAL '1 year', NOW(), '1 day'::interval) date")
.select("*").from("full_year")
# WITH full_year AS ( SELECT DATE(date) ... ) SELECT * FROM full_year;
def with_cte(tuple : NamedTuple)
#
Add a CTE to the query. Use NamedTuple convention:
Clear::SQL.select.with_cte(cte: "xxx")
# WITH cte AS xxx SELECT...