DuckDB v0.10.1 for Pascal

The Pascal API structure aligns with C++ DuckDB v0.10.1.

Record Relation

Description
Hierarchy
Fields
Methods
Properties

Unit

ddb

Declaration

type Relation = record

Description

Class: Relation of ddb

Overview

Fields

Public o: Pduckdb_Relation;

Methods

Public constructor FromNativePointer(ptr : Pduckdb_Relation);
Public class operator Explicit(const r: Relation): Boolean;
Public procedure AutoRelease();
Public function context(): ClientContextWrapper; overload;
Public function type(): Integer; overload;
Public function Columns(): vector_ColumnDefinition; overload;
Public function GetQueryNode(): QueryNode; overload;
Public function GetAlias(): str; overload;
Public function ExecuteOrThrow(): QueryResult; overload;
Public function Execute(): QueryResult; overload;
Public function ToString(): str; overload;
Public function ToString(arg2: UInt64): str; overload;
Public procedure Print(); overload;
Public procedure Head(arg2: UInt64); overload;
Public procedure Head(); overload;
Public function CreateView(arg2: str; arg3: Boolean; arg4: Boolean): std_shared_ptr_duckdb_Relation; overload;
Public function CreateView(arg2: str; arg3: Boolean): std_shared_ptr_duckdb_Relation; overload;
Public function CreateView(arg2: str): std_shared_ptr_duckdb_Relation; overload;
Public function CreateView(arg2: str; arg3: str; arg4: Boolean; arg5: Boolean): std_shared_ptr_duckdb_Relation; overload;
Public function CreateView(arg2: str; arg3: str; arg4: Boolean): std_shared_ptr_duckdb_Relation; overload;
Public function CreateView(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;
Public function Query(arg2: str): QueryResult; overload;
Public function Query(arg2: str; arg3: str): QueryResult; overload;
Public function Explain(arg2: Integer): QueryResult; overload;
Public function Explain(): QueryResult; overload;
Public function GetTableRef(): TableRef; overload;
Public function IsReadOnly(): Boolean; overload;
Public function Project(arg2: str): std_shared_ptr_duckdb_Relation; overload;
Public function Project(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;
Public function Project(arg2: str; arg3: vector_str): std_shared_ptr_duckdb_Relation; overload;
Public function Project(arg2: vector_str): std_shared_ptr_duckdb_Relation; overload;
Public function Project(arg2: vector_str; arg3: vector_str): std_shared_ptr_duckdb_Relation; overload;
Public function Filter(arg2: str): std_shared_ptr_duckdb_Relation; overload;
Public function Filter(arg2: ParsedExpression): std_shared_ptr_duckdb_Relation; overload;
Public function Filter(arg2: vector_str): std_shared_ptr_duckdb_Relation; overload;
Public function Limit(arg2: Int64; arg3: Int64): std_shared_ptr_duckdb_Relation; overload;
Public function Limit(arg2: Int64): std_shared_ptr_duckdb_Relation; overload;
Public function Order(arg2: str): std_shared_ptr_duckdb_Relation; overload;
Public function Order(arg2: vector_str): std_shared_ptr_duckdb_Relation; overload;
Public function Join(arg2: std_shared_ptr_duckdb_Relation; arg3: str; arg4: Integer; arg5: Integer): std_shared_ptr_duckdb_Relation; overload;
Public function Join(arg2: std_shared_ptr_duckdb_Relation; arg3: str; arg4: Integer): std_shared_ptr_duckdb_Relation; overload;
Public function Join(arg2: std_shared_ptr_duckdb_Relation; arg3: str): std_shared_ptr_duckdb_Relation; overload;
Public function CrossProduct(arg2: std_shared_ptr_duckdb_Relation; arg3: Integer): std_shared_ptr_duckdb_Relation; overload;
Public function CrossProduct(arg2: std_shared_ptr_duckdb_Relation): std_shared_ptr_duckdb_Relation; overload;
Public function Union(arg2: std_shared_ptr_duckdb_Relation): std_shared_ptr_duckdb_Relation; overload;
Public function Except(arg2: std_shared_ptr_duckdb_Relation): std_shared_ptr_duckdb_Relation; overload;
Public function Intersect(arg2: std_shared_ptr_duckdb_Relation): std_shared_ptr_duckdb_Relation; overload;
Public function Distinct(): std_shared_ptr_duckdb_Relation; overload;
Public function Aggregate(arg2: str): std_shared_ptr_duckdb_Relation; overload;
Public function Aggregate(arg2: vector_str): std_shared_ptr_duckdb_Relation; overload;
Public function Aggregate(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;
Public function Aggregate(arg2: vector_str; arg3: vector_str): std_shared_ptr_duckdb_Relation; overload;
Public function Alias(arg2: str): std_shared_ptr_duckdb_Relation; overload;
Public function InsertRel(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;
Public procedure Insert(arg2: str); overload;
Public procedure Insert(arg2: str; arg3: str); overload;
Public procedure Insert(arg2: vector_vector_Value); overload;
Public function CreateRel(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;
Public procedure Update(arg2: str; arg3: str); overload;
Public procedure Update(arg2: str); overload;
Public procedure Delete(arg2: str); overload;
Public procedure Delete(); overload;
Public function InheritsColumnBindings(): Boolean; overload;
Public function ChildRelation(): Relation; overload;
Public function GetAllDependencies(): duckdb_vector_std_shared_ptr_duckdb_ExternalDependency; overload;

Description

Fields

Public o: Pduckdb_Relation;

This item has no description.

Methods

Public constructor FromNativePointer(ptr : Pduckdb_Relation);

This item has no description.

Public class operator Explicit(const r: Relation): Boolean;

This item has no description.

Public procedure AutoRelease();

This item has no description.

Public function context(): ClientContextWrapper; overload;

This item has no description.

Public function type(): Integer; overload;

This item has no description.

Public function Columns(): vector_ColumnDefinition; overload;

This item has no description.

Public function GetQueryNode(): QueryNode; overload;

This item has no description.

Public function GetAlias(): str; overload;

This item has no description.

Public function ExecuteOrThrow(): QueryResult; overload;

This item has no description.

Public function Execute(): QueryResult; overload;

This item has no description.

Public function ToString(): str; overload;

This item has no description.

Public function ToString(arg2: UInt64): str; overload;

This item has no description.

Public procedure Print(); overload;

This item has no description.

Public procedure Head(arg2: UInt64); overload;

This item has no description.

Public procedure Head(); overload;

This item has no description.

Public function CreateView(arg2: str; arg3: Boolean; arg4: Boolean): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function CreateView(arg2: str; arg3: Boolean): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function CreateView(arg2: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function CreateView(arg2: str; arg3: str; arg4: Boolean; arg5: Boolean): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function CreateView(arg2: str; arg3: str; arg4: Boolean): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function CreateView(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Query(arg2: str): QueryResult; overload;

This item has no description.

Public function Query(arg2: str; arg3: str): QueryResult; overload;

This item has no description.

Public function Explain(arg2: Integer): QueryResult; overload;

This item has no description.

Public function Explain(): QueryResult; overload;

This item has no description.

Public function GetTableRef(): TableRef; overload;

This item has no description.

Public function IsReadOnly(): Boolean; overload;

This item has no description.

Public function Project(arg2: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Project(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Project(arg2: str; arg3: vector_str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Project(arg2: vector_str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Project(arg2: vector_str; arg3: vector_str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Filter(arg2: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Filter(arg2: ParsedExpression): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Filter(arg2: vector_str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Limit(arg2: Int64; arg3: Int64): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Limit(arg2: Int64): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Order(arg2: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Order(arg2: vector_str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Join(arg2: std_shared_ptr_duckdb_Relation; arg3: str; arg4: Integer; arg5: Integer): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Join(arg2: std_shared_ptr_duckdb_Relation; arg3: str; arg4: Integer): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Join(arg2: std_shared_ptr_duckdb_Relation; arg3: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function CrossProduct(arg2: std_shared_ptr_duckdb_Relation; arg3: Integer): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function CrossProduct(arg2: std_shared_ptr_duckdb_Relation): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Union(arg2: std_shared_ptr_duckdb_Relation): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Except(arg2: std_shared_ptr_duckdb_Relation): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Intersect(arg2: std_shared_ptr_duckdb_Relation): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Distinct(): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Aggregate(arg2: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Aggregate(arg2: vector_str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Aggregate(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Aggregate(arg2: vector_str; arg3: vector_str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function Alias(arg2: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public function InsertRel(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public procedure Insert(arg2: str); overload;

This item has no description.

Public procedure Insert(arg2: str; arg3: str); overload;

This item has no description.

Public procedure Insert(arg2: vector_vector_Value); overload;

This item has no description.

Public function CreateRel(arg2: str; arg3: str): std_shared_ptr_duckdb_Relation; overload;

This item has no description.

Public procedure Update(arg2: str; arg3: str); overload;

This item has no description.

Public procedure Update(arg2: str); overload;

This item has no description.

Public procedure Delete(arg2: str); overload;

This item has no description.

Public procedure Delete(); overload;

This item has no description.

Public function InheritsColumnBindings(): Boolean; overload;

This item has no description.

Public function ChildRelation(): Relation; overload;

This item has no description.

Public function GetAllDependencies(): duckdb_vector_std_shared_ptr_duckdb_ExternalDependency; overload;

This item has no description.

Error Message