SQLVERSION()

All functions > METADATA > SQLVERSION()

Returns the active SQL dialect name and the backend database version.

Signatures

Returns: FeatureQL dialect name and engine version() string

SQLVERSION() → ROW(dialect VARCHAR, version VARCHAR)

Notes

• dialect is the FeatureQL base dialect name (for example DUCKDB, TRINO, DATAFUSION)
• version is the backend engine version string from version()
• Compare with VERSION(), which reports the FeatureMesh registry version
• Use SELECT SQLVERSION()[dialect] or SELECT SQLVERSION()[version] for single columns

See also

• Metadata functions

Examples

SQLVERSION dialect and non-null version

RETURN
    dialect_known := SQLVERSION()[dialect] IN (
        'DUCKDB',
        'TRINO',
        'BIGQUERY',
        'DATAFUSION'
    ),
    has_engine_version := LENGTH(SQLVERSION()[version]) > 0
;