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
sql
ParameterTypeRequiredDescription
exprTYesThe expression to describe

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

Examples

Scalars (FeatureQL vs execution target)

FeatureQL
RETURN
    f1 := SQLTYPEOF(1)
;
Result
f1 VARCHAR
BIGINT

Containers

FeatureQL
RETURN
    -- FeatureQL BIGINT maps to Int64 in DataFusion
    f1 := SQLTYPEOF(1)
;
Result
f1 VARCHAR
Int64