SQLTYPEOF
All functions > CONVERSION > SQLTYPEOF
Returns the type of the given expression in the target database.
Syntax
SQLTYPEOF(expr)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
expr | BIGINT | Yes | The expression to get the SQL type of |
Returns
A string representing the database-specific SQL type
Notes
- Returns the target database's type name as a string
- Type name varies by database engine (Trino, DuckDB, etc.)
- Useful for debugging type translations
- Shows how FeatureQL types map to SQL types
- Type is determined at query translation time
- Can differ from TYPEOF which shows FeatureQL types