SQLTYPEOF()

All functions > METADATA > SQLTYPEOF()

Returns the name of the translated storage type for the expression (after FeatureQL is lowered for execution).

Signatures

Returns: A string naming the execution target's type for that expression

SQLTYPEOF(expr: T) → VARCHAR

Notes

• Spelling is defined by the active execution target, not by FeatureQL's type names
• Compare with TYPEOF, which reports the FeatureQL type
• Useful when debugging how a value is represented after translation

See also

• Metadata functions

Examples

Scalars (FeatureQL vs execution target)

SELECT
    f1 := SQLTYPEOF(1) -- FeatureQL BIGINT may map to INTEGER in DuckDB
;

Containers

SELECT
    f1 := SQLTYPEOF(ARRAY[1, 2]) -- Array spelling follows the active backend
;