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. |
KEY_TO_SCALAR() | ✓ | ✓ | ✓ | Drop the entity annotation and keep the base type and unit |
KEY_PAIR() | ✓ | ✓ | ✓ | Unordered pair of two identity keys from one family |
IS_KEY_BEFORE() | ✓ | ✓ | ✓ | True when the first identity key is strictly before the second |
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 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 |
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: 18