Skip to main content

uqa_execution/query/block/
foreign.rs

1//
2// Unified Query Algebra
3//
4// Copyright (c) 2023-2026 Cognica, Inc.
5//
6
7//! Foreign-table pushdown and execution.
8
9use super::{
10    execute_query_block_operator_output, expand_from_star_columns, projection_columns, CteScope,
11    QueryBlockPlan, QueryOutput, QueryOutputMode, SQLError, SQLParam, SingleRelation,
12    SourceContext,
13};
14
15mod predicates;
16pub use predicates::*;
17
18pub fn run_single_foreign_select_output<'a, S: Clone + Send + Sync + 'static>(
19    context: &SourceContext<'a, S>,
20    relation: SingleRelation<'_>,
21    block: &'a QueryBlockPlan,
22    stmt: &'a QueryBlockPlan,
23    params: &'a [SQLParam],
24    ctes: &'a CteScope<S>,
25    output_mode: QueryOutputMode<'a>,
26) -> Result<QueryOutput, SQLError> {
27    let SingleRelation {
28        reference_name: _,
29        relation_name: table,
30        qualifier,
31    } = relation;
32    let catalog = ctes.catalog_read_view()?;
33    let resolution = ctes.relation_name_resolution()?;
34    let foreign_table = catalog
35        .foreign_table_resolved(&resolution, table)?
36        .ok_or_else(|| SQLError::UnknownTable(table.to_string()))?;
37    let definitions = &catalog.snapshot().definitions;
38    foreign_table
39        .bound_server(&definitions.foreign_servers)?
40        .bound_wrapper(&definitions.foreign_wrappers)?
41        .require_handler()?;
42    let scanned = context
43        .scan_foreign_source(table, stmt.r#where.as_ref(), params)
44        .map_err(SQLError::Unsupported)?;
45    let source_schema =
46        crate::RowSchema::with_column_definitions(Some(qualifier), &foreign_table.columns);
47    let source: Box<dyn crate::PhysicalOperator + '_> =
48        Box::new(crate::RowIteratorScan::with_row_schema(
49            source_schema,
50            Box::new(scanned.map(|row| {
51                row.map_err(SQLError::Unsupported)
52                    .map_err(crate::ExecError::from)
53            })),
54        ));
55    let bound_columns = match stmt.from.as_ref() {
56        Some(uqa_sql::plan::SourcePlan::Table { bound_columns, .. }) => bound_columns.as_deref(),
57        _ => None,
58    };
59    let source = crate::query::source_projection::bound_source_operator(source, bound_columns)?;
60    let source = context
61        .scans
62        .runtime
63        .diagnostics
64        .observe(source, "Foreign Scan")?;
65    let columns = expand_from_star_columns(
66        projection_columns(&stmt.projections),
67        &stmt.projections,
68        source.row_schema(),
69    )?;
70    execute_query_block_operator_output(
71        context.relational,
72        source,
73        stmt.r#where.as_ref(),
74        stmt,
75        block,
76        params,
77        ctes,
78        columns,
79        output_mode,
80    )
81}