v2026.11.2
All Bundles
Bundle

In-memory query engine over typed columns. Tables are filled row by row or loaded from sources (CSV files, folders, the program's own objects) and queried with SQL-like statements; aggregates, Describe() and Finder (file search) are included. Compile with -lib query.

Col

Starts a condition on a column

Example

p := Col->Of("value")->Gt(0.5)->AndAlso(Col->Of("grp")->Eq("g7"));

Operations

Between #

Between two values, both included

method : public : Between(low:Compare, high:Compare) ~ Predicate

Parameters

NameTypeDescription
lowComparelowest value
highComparehighest value

Return

TypeDescription
Predicatecondition

Between #

Between two Floats, both included

method : public : Between(low:Float, high:Float) ~ Predicate

Parameters

NameTypeDescription
lowFloatlowest value
highFloathighest value

Return

TypeDescription
Predicatecondition

Eq #

Equal to a value

method : public : Eq(value:Compare) ~ Predicate

Parameters

NameTypeDescription
valueComparevalue

Return

TypeDescription
Predicatecondition

Eq #

Equal to an Int

method : public : Eq(value:Int) ~ Predicate

Parameters

NameTypeDescription
valueIntvalue

Return

TypeDescription
Predicatecondition

Eq #

Equal to a Float

method : public : Eq(value:Float) ~ Predicate

Parameters

NameTypeDescription
valueFloatvalue

Return

TypeDescription
Predicatecondition

Eq #

Equal to a Bool

method : public : Eq(value:Bool) ~ Predicate

Parameters

NameTypeDescription
valueBoolvalue

Return

TypeDescription
Predicatecondition

Ge #

Greater than or equal to a value

method : public : Ge(value:Compare) ~ Predicate

Parameters

NameTypeDescription
valueComparevalue

Return

TypeDescription
Predicatecondition

Ge #

Greater than or equal to an Int

method : public : Ge(value:Int) ~ Predicate

Parameters

NameTypeDescription
valueIntvalue

Return

TypeDescription
Predicatecondition

Ge #

Greater than or equal to a Float

method : public : Ge(value:Float) ~ Predicate

Parameters

NameTypeDescription
valueFloatvalue

Return

TypeDescription
Predicatecondition

Gt #

Greater than a value

method : public : Gt(value:Compare) ~ Predicate

Parameters

NameTypeDescription
valueComparevalue

Return

TypeDescription
Predicatecondition

Gt #

Greater than an Int

method : public : Gt(value:Int) ~ Predicate

Parameters

NameTypeDescription
valueIntvalue

Return

TypeDescription
Predicatecondition

Gt #

Greater than a Float

method : public : Gt(value:Float) ~ Predicate

Parameters

NameTypeDescription
valueFloatvalue

Return

TypeDescription
Predicatecondition

In #

Equal to any of the values

method : public : In(values:Compare[]) ~ Predicate

Parameters

NameTypeDescription
valuesComparevalues

Return

TypeDescription
Predicatecondition

In #

Equal to any of the strings

method : public : In(values:String[]) ~ Predicate

Parameters

NameTypeDescription
valuesStringvalues

Return

TypeDescription
Predicatecondition

In #

Equal to any of the Ints

method : public : In(values:Int[]) ~ Predicate

Parameters

NameTypeDescription
valuesIntvalues

Return

TypeDescription
Predicatecondition

In #

Equal to any of the Floats

method : public : In(values:Float[]) ~ Predicate

Parameters

NameTypeDescription
valuesFloatvalues

Return

TypeDescription
Predicatecondition

IsNotNull #

The cell is not empty

method : public : IsNotNull() ~ Predicate

Return

TypeDescription
Predicatecondition

IsNull #

The cell is empty

method : public : IsNull() ~ Predicate

Return

TypeDescription
Predicatecondition

Le #

Less than or equal to a value

method : public : Le(value:Compare) ~ Predicate

Parameters

NameTypeDescription
valueComparevalue

Return

TypeDescription
Predicatecondition

Le #

Less than or equal to an Int

method : public : Le(value:Int) ~ Predicate

Parameters

NameTypeDescription
valueIntvalue

Return

TypeDescription
Predicatecondition

Le #

Less than or equal to a Float

method : public : Le(value:Float) ~ Predicate

Parameters

NameTypeDescription
valueFloatvalue

Return

TypeDescription
Predicatecondition

Like #

Matches an SQL LIKE pattern: '%' any run of characters, '_' any one character

method : public : Like(pattern:String) ~ Predicate

Parameters

NameTypeDescription
patternStringpattern

Return

TypeDescription
Predicatecondition

Lt #

Less than a value

method : public : Lt(value:Compare) ~ Predicate

Parameters

NameTypeDescription
valueComparevalue

Return

TypeDescription
Predicatecondition

Lt #

Less than an Int

method : public : Lt(value:Int) ~ Predicate

Parameters

NameTypeDescription
valueIntvalue

Return

TypeDescription
Predicatecondition

Lt #

Less than a Float

method : public : Lt(value:Float) ~ Predicate

Parameters

NameTypeDescription
valueFloatvalue

Return

TypeDescription
Predicatecondition

Matches #

The whole cell matches a regular expression (Query.RegEx); only text cells take part

method : public : Matches(pattern:String) ~ Predicate

Parameters

NameTypeDescription
patternStringregular expression

Return

TypeDescription
Predicatecondition

Ne #

Not equal to a value; true for cells that cannot be compared with it

method : public : Ne(value:Compare) ~ Predicate

Parameters

NameTypeDescription
valueComparevalue

Return

TypeDescription
Predicatecondition

Ne #

Not equal to an Int

method : public : Ne(value:Int) ~ Predicate

Parameters

NameTypeDescription
valueIntvalue

Return

TypeDescription
Predicatecondition

Ne #

Not equal to a Float

method : public : Ne(value:Float) ~ Predicate

Parameters

NameTypeDescription
valueFloatvalue

Return

TypeDescription
Predicatecondition

New # constructor

Constructor

New(name:String)

Parameters

NameTypeDescription
nameStringcolumn name

NotLike #

Does not match an SQL LIKE pattern; only text cells take part

method : public : NotLike(pattern:String) ~ Predicate

Parameters

NameTypeDescription
patternStringpattern

Return

TypeDescription
Predicatecondition

NotMatches #

The cell does not match a regular expression; only text cells take part

method : public : NotMatches(pattern:String) ~ Predicate

Parameters

NameTypeDescription
patternStringregular expression

Return

TypeDescription
Predicatecondition

Of # function

Starts a condition on a column

function : Of(name:String) ~ Col

Parameters

NameTypeDescription
nameStringcolumn name

Return

TypeDescription
Colcolumn reference