Type Alias Qail 

pub type Qail = Qail;

Ergonomic alias for Qail - the primary query builder type.

Aliased Type

pub struct Qail {

    pub action: Action,
    pub table: String,
    pub columns: Vec<Expr>,
    pub joins: Vec<Join>,
    pub cages: Vec<Cage>,
    pub distinct: bool,
    pub index_def: Option<IndexDef>,
    pub table_constraints: Vec<TableConstraint>,
    pub set_ops: Vec<(SetOp, Box<Qail>)>,
    pub having: Vec<Condition>,
    pub group_by_mode: GroupByMode,
    pub ctes: Vec<CTEDef>,
    pub distinct_on: Vec<Expr>,
    pub returning: Option<Vec<Expr>>,
    pub on_conflict: Option<OnConflict>,
    pub source_query: Option<Box<Qail>>,
    pub channel: Option<String>,
    pub payload: Option<String>,
    pub savepoint_name: Option<String>,
    pub from_tables: Vec<String>,
    pub using_tables: Vec<String>,
    pub lock_mode: Option<LockMode>,
    pub skip_locked: bool,
    pub fetch: Option<(u64, bool)>,
    pub default_values: bool,
    pub overriding: Option<OverridingKind>,
    pub sample: Option<(SampleMethod, f64, Option<u64>)>,
    pub only_table: bool,
    pub vector: Option<Vec<f32>>,
    pub score_threshold: Option<f32>,
    pub vector_name: Option<String>,
    pub with_vector: bool,
    pub vector_size: Option<u64>,
    pub distance: Option<Distance>,
    pub on_disk: Option<bool>,
    pub function_def: Option<FunctionDef>,
    pub trigger_def: Option<TriggerDef>,
    pub policy_def: Option<RlsPolicy>,
}

Fields

action: Action

SQL action to perform.

table: String

Target table name.

columns: Vec<Expr>

Selected / inserted / modified columns.

joins: Vec<Join>

Join clauses.

cages: Vec<Cage>

Filter / sort / group / limit cages.

distinct: bool

SELECT DISTINCT.

index_def: Option<IndexDef>

Index definition for CREATE INDEX.

table_constraints: Vec<TableConstraint>

Table-level constraints (composite UNIQUE / PK).

set_ops: Vec<(SetOp, Box<Qail>)>

UNION / INTERSECT / EXCEPT operations.

having: Vec<Condition>

HAVING clause conditions.

group_by_mode: GroupByMode

GROUP BY mode (simple, rollup, cube, grouping sets).

ctes: Vec<CTEDef>

Common table expressions (WITH).

distinct_on: Vec<Expr>

DISTINCT ON columns.

returning: Option<Vec<Expr>>

RETURNING clause.

on_conflict: Option<OnConflict>

ON CONFLICT clause for upsert.

source_query: Option<Box<Qail>>

INSERT … SELECT source query.

channel: Option<String>

LISTEN/NOTIFY channel.

payload: Option<String>

NOTIFY payload.

savepoint_name: Option<String>

SAVEPOINT name.

from_tables: Vec<String>

UPDATE … FROM additional tables.

using_tables: Vec<String>

DELETE … USING additional tables.

lock_mode: Option<LockMode>

Row locking (FOR UPDATE / FOR SHARE).

skip_locked: bool

SKIP LOCKED modifier for row locking (FOR UPDATE SKIP LOCKED).

fetch: Option<(u64, bool)>

FETCH FIRST n ROWS [ONLY|WITH TIES].

default_values: bool

INSERT with DEFAULT VALUES.

overriding: Option<OverridingKind>

OVERRIDING clause for generated columns.

sample: Option<(SampleMethod, f64, Option<u64>)>

TABLESAMPLE method, percentage, and optional seed.

only_table: bool

SELECT FROM ONLY (exclude inheritance).

vector: Option<Vec<f32>>

Search vector for similarity queries.

score_threshold: Option<f32>

Minimum score threshold.

vector_name: Option<String>

Named vector in multi-vector collections.

with_vector: bool

Include vector data in results.

vector_size: Option<u64>

Vector dimensionality.

distance: Option<Distance>

Distance metric.

on_disk: Option<bool>

Store vectors on disk.

function_def: Option<FunctionDef>

Function definition.

trigger_def: Option<TriggerDef>

Trigger definition.

policy_def: Option<RlsPolicy>

RLS policy definition.