Struct CteDefinition 

pub struct CteDefinition {
    pub name: String,
    pub columns: Vec<String>,
    pub query: Box<QueryExpr>,
    pub recursive: bool,
}

A Common Table Expression (CTE) definition

CTEs provide named subqueries that can be referenced multiple times within the main query. Recursive CTEs enable hierarchical queries.

Examples

-- Non-recursive CTE
WITH active_hosts AS (
    SELECT * FROM hosts WHERE last_seen > now() - interval '1 hour'
)
SELECT * FROM active_hosts WHERE criticality > 5

-- Recursive CTE for attack paths
WITH RECURSIVE attack_path AS (
    -- Base case: starting host
    SELECT id, ip, 0 as depth FROM hosts WHERE ip = '192.168.1.1'
    UNION ALL
    -- Recursive case: follow connections
    SELECT h.id, h.ip, ap.depth + 1
    FROM attack_path ap
    JOIN connections c ON c.source_id = ap.id
    JOIN hosts h ON h.id = c.target_id
    WHERE ap.depth < 10
)
SELECT * FROM attack_path

Fields

name: String

Name of the CTE (used to reference it in the main query)

columns: Vec<String>

Optional column aliases for the CTE result

query: Box<QueryExpr>

The query that defines this CTE

recursive: bool

Whether this is a recursive CTE

Implementations

impl CteDefinition

pub fn new(name: &str, query: QueryExpr) -> Self

Create a new non-recursive CTE

pub fn recursive(name: &str, query: QueryExpr) -> Self

Create a recursive CTE

pub fn with_columns(self, columns: Vec<String>) -> Self

Add column aliases

Trait Implementations

impl Clone for CteDefinition

fn clone(&self) -> CteDefinition

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for CteDefinition

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.