Struct SelectBuilder 

pub struct SelectBuilder { /* private fields */ }

SELECT query builder.

Implementations

impl SelectBuilder

pub fn from(self, table: &str) -> Self

Sets the FROM table.

pub fn where_(self, predicate: &Expr) -> Self

Sets the WHERE clause.

pub fn order_by(self, column: &str, order: JsSortOrder) -> Self

Adds an ORDER BY clause.

pub fn limit(self, n: usize) -> Self

Sets the LIMIT.

pub fn offset(self, n: usize) -> Self

Sets the OFFSET.

pub fn inner_join(self, table: &str, condition: &Expr) -> Self

Adds an INNER JOIN.

pub fn left_join(self, table: &str, condition: &Expr) -> Self

Adds a LEFT JOIN.

pub fn group_by(self, columns: &JsValue) -> Self

Adds a GROUP BY clause.

pub fn count(self) -> Self

Adds a COUNT(*) aggregate.

pub fn count_col(self, column: &str) -> Self

Adds a COUNT(column) aggregate.

pub fn sum(self, column: &str) -> Self

Adds a SUM(column) aggregate.

pub fn avg(self, column: &str) -> Self

Adds an AVG(column) aggregate.

pub fn min(self, column: &str) -> Self

Adds a MIN(column) aggregate.

pub fn max(self, column: &str) -> Self

Adds a MAX(column) aggregate.

pub fn stddev(self, column: &str) -> Self

Adds a STDDEV(column) aggregate.

pub fn geomean(self, column: &str) -> Self

Adds a GEOMEAN(column) aggregate.

pub fn distinct(self, column: &str) -> Self

Adds a DISTINCT(column) aggregate (returns count of distinct values).

pub async fn exec(&self) -> Result<JsValue, JsValue>

Executes the query and returns results.

pub fn explain(&self) -> Result<JsValue, JsValue>

Explains the query plan without executing it.

Returns an object with:

• logical: The original logical plan
• optimized: The optimized logical plan (after index selection, etc.)
• physical: The final physical execution plan

pub fn observe(&self) -> Result<JsObservableQuery, JsValue>

Creates an observable query using re-query strategy. When data changes, the cached physical plan is re-executed (no optimization overhead).

pub fn changes(&self) -> Result<JsChangesStream, JsValue>

Creates a changes stream (initial + incremental).

pub fn get_schema_layout(&self) -> Result<SchemaLayout, JsValue>

Gets the schema layout for binary decoding. The layout can be cached by JS for repeated queries on the same table.

pub async fn exec_binary(&self) -> Result<BinaryResult, JsValue>

Executes the query and returns a binary result buffer. Use with getSchemaLayout() for zero-copy decoding in JS.

Trait Implementations

impl From<SelectBuilder> for JsValue

fn from(value: SelectBuilder) -> Self

Converts to this type from the input type.

impl FromWasmAbi for SelectBuilder

type Abi = u32

The Wasm ABI type that this converts from when coming back out from the ABI boundary.

unsafe fn from_abi(js: u32) -> Self

Recover a Self from Self::Abi.

impl IntoWasmAbi for SelectBuilder

type Abi = u32

The Wasm ABI type that this converts into when crossing the ABI boundary.

fn into_abi(self) -> u32

Convert self into Self::Abi so that it can be sent across the wasm ABI boundary.

impl LongRefFromWasmAbi for SelectBuilder

type Abi = u32

Same as RefFromWasmAbi::Abi

type Anchor = RcRef<SelectBuilder>

Same as RefFromWasmAbi::Anchor

unsafe fn long_ref_from_abi(js: Self::Abi) -> Self::Anchor

Same as RefFromWasmAbi::ref_from_abi

impl OptionFromWasmAbi for SelectBuilder

fn is_none(abi: &Self::Abi) -> bool

Tests whether the argument is a “none” instance. If so it will be deserialized as None, and otherwise it will be passed to FromWasmAbi.

impl OptionIntoWasmAbi for SelectBuilder

fn none() -> Self::Abi

Returns an ABI instance indicating “none”, which JS will interpret as the None branch of this option.

impl RefFromWasmAbi for SelectBuilder

type Abi = u32

The Wasm ABI type references to Self are recovered from.

type Anchor = RcRef<SelectBuilder>

The type that holds the reference to Self for the duration of the invocation of the function that has an &Self parameter. This is required to ensure that the lifetimes don’t persist beyond one function call, and so that they remain anonymous.

unsafe fn ref_from_abi(js: Self::Abi) -> Self::Anchor

Recover a Self::Anchor from Self::Abi.

impl RefMutFromWasmAbi for SelectBuilder

type Abi = u32

Same as RefFromWasmAbi::Abi

type Anchor = RcRefMut<SelectBuilder>

Same as RefFromWasmAbi::Anchor

unsafe fn ref_mut_from_abi(js: Self::Abi) -> Self::Anchor

Same as RefFromWasmAbi::ref_from_abi

impl TryFromJsValue for SelectBuilder

fn try_from_js_value(value: JsValue) -> Result<Self, JsValue>

Performs the conversion.

fn try_from_js_value_ref(value: &JsValue) -> Option<Self>

Performs the conversion.

impl VectorFromWasmAbi for SelectBuilder

type Abi = <Box<[JsValue]> as FromWasmAbi>::Abi

unsafe fn vector_from_abi(js: Self::Abi) -> Box<[SelectBuilder]>

impl VectorIntoWasmAbi for SelectBuilder

type Abi = <Box<[JsValue]> as IntoWasmAbi>::Abi

fn vector_into_abi(vector: Box<[SelectBuilder]>) -> Self::Abi

impl WasmDescribe for SelectBuilder

fn describe()

impl WasmDescribeVector for SelectBuilder

fn describe_vector()

impl SupportsConstructor for SelectBuilder

impl SupportsInstanceProperty for SelectBuilder

impl SupportsStaticProperty for SelectBuilder