Reference / deterministic subset

Query support, with the caveats left in view.

Rulattice translates a bounded set of constructs through one canonical model. This page lists what each adapter reads and writes, how meaning is preserved, and what is rejected. A structural match is not proof that the destination schema carries the same meaning.

Supported constructs

ConstructKQLSplunk SPLCortex XQLCQL / LogScale
SourceTableindex=xdataset = x#event_simpleName=x / #repo=x
Relative timeTimeGenerated >= ago(1h), between (ago(1h) .. now())earliest=-1hconfig timeframe = 1hsetTimeInterval(start=1h), test(@timestamp >= now() - duration("1h"))
Boolean logicand or not()AND OR NOT, implicit ANDand or notand or not !, implicit AND
Equality== != =~ !~= != (search), = == != (where)= !== !=
Numeric compare> >= < <=samesametest(x > 5)
Contains / prefix / suffixcontains startswith endswith (+ _cs), has"*v*" (search), like(), match()contains, ~="*v*", /v/i, wildcard()
Listsin in~ !inIN ( ), in()in ( ) not inin(field=, values=[ ])
Regexmatches regexmatch()~=/re/flags, regex()
Fieldsproject project-awayfields, fields -, tablefields, fields -xselect() table() drop()
Aggregationsummarize count() dcount() sum() min() max() avg() by, countstats count dc sum min max avg BYcomp count() count_distinct() ... bygroupBy(), count(), stats()
Computed fieldsextend a = expr, b = expreval a=expr, b=expralter a = expra := expr, eval(a = expr), lower()/upper()/length(f, as=), concat([f], as=)
Functionstolower toupper strlen strcat substring coalesce tostring todouble iff caselower upper len . substr coalesce tostring tonumber if caselowercase uppercase len concat coalesce to_string to_number if add subtract multiply dividearithmetic, lower upper length concat
Renamesproject-rename new = oldrename old AS newemitted as alter + fields -rename(field=, as=)
Constantslet name = literal; (inlined)n/an/an/a
Event classesDeviceProcessEvents..., SecurityEvent 4688, ASIM _Im_*Sysmon EventCode, Windows 4688event_type / event_sub_type / agent_os_type = ENUM.*#event_simpleName + event_platform / ECS event.*
Sort / limitsort by, order by, take, topsort, headsort asc|desc, limitsort(), head()

Semantics that are preserved

Schema mapping (opt-in)

Off by default: field names are preserved and known entity fields are flagged. Turn on "Map fields to target data model" to rename them. Every mapping appears as a review item.

EntityKQL (ASIM)SPL (CIM)XQL (XDM)CQL (Falcon)LogScale (ECS-style)Caveat

Known gaps and rejection behavior

Unsupported input returns no partial output. You get the reason instead.

Open the translator