4.3 Query Engine and Optimization Spotlight 9’s SQL engine implements cost-based optimization, column pruning, and materialized view support. It supports user-defined functions (UDFs) in sandboxed runtimes (WASM or JVM) and features a query cache for repeated analytics workloads.