All functions > CORE
All functions in the CORE category.
Semantics
| Function | DuckDB | Trino | Serving | Description |
|---|
ENTITY() | ✓ | ✓ | ✓ | Returns a reference to an entity. |
INPUT() | ✓ | ✓ | ✓ | Returns a reference to an input. |
Bind
| Function | DuckDB | Trino | Serving | Description |
|---|
BIND_VALUE() | ✓ | ✓ | ✓ | Binds the given value to the given feature. |
BIND_VALUES() | ✓ | ✓ | ✓ | Binds the given array of values to the given feature or features. |
BIND_COLUMNS() | ✓ | ✓ | ✓ | Binds columns from a table to the given features. |
@BIND_KEYSET(...) | ✓ | ✓ | ✓ | Binds entity keys from a keyset, keyset group, or active mapped source. |
Structural
| Function | DuckDB | Trino | Serving | Description |
|---|
RELATED() | ✓ | ✓ | ✓ | Joins a feature or an aggregation using a key as base |
UNNEST() | ✓ | ✓ | ✓ | Unnests an array of rows into a table of rows |
Types
| Function | DuckDB | Trino | Serving | Description |
|---|
CAST() | ✓ | ✓ | ✓ | Returns the given expression casted to the given type, or raise an exception if the conversion... |
UNSAFE_CAST() | ✓ | ✓ | ✓ | Returns the given expression casted to the given type, allowing to change or remove entity type |
TRY_CAST() | ✓ | ✓ | ✓ | Returns the given expression casted to the given type, or NULL if the cast fails. |
NULL() | ✓ | ✓ | ✓ | Returns a NULL value of the given type. |
EMPTY() | ✓ | ✓ | ✓ | Returns an EMPTY filling for empty parameters in functions. |
Functions
| Function | DuckDB | Trino | Serving | Description |
|---|
VARIANT() | ✓ | ✓ | ✓ | Returns a reference to a variant of the given feature with the given replacements in its... |
MACRO() | ✓ | ✓ | ✓ | Returns a reference to a macro of the given feature with the given inputs. |
UDF() | ✓ | ✓ | ✓ | Defines a polymorphic user-defined function with typed signatures and dialect SQL expressions. |
Summary
Functions in this category: 16