Use this skill when writing ClickHouse SQL transformation passes, pipelines, macro expanders, function evaluators, or analysis functions using the nanopass framework. Triggers include: any mention of 'nanopass', 'SQL pass', 'SQL transformation', 'SQL rewrite', 'ClickHouse pass', 'canonicalize SQL', 'macro expansion', 'qualify tables', 'expand columns', 'extract literals', 'add/modify SETTINGS', or requests to manipulate ClickHouse SQL programmatically in Go. Also use when parsing ClickHouse SQL, walking a CST, rewriting tokens, building scope-aware transformations, declaring PassProperties, or composing SQLโSQL pipelines with Sequence/FixedPoint. Do NOT use for general SQL querying, ClickHouse client usage, or ORM-based database access.
Use when writing imzero2 / egui2 GUI code โ the FFFI render pipeline, memory management, the deterministic XOR id stack, retained/deferred bodies, and widget contracts.
Use for advanced Leeway columnar modelling โ multi-membership encoding, co-sections, membership roles, and mapping JSON to an equivalent Leeway representation.
Use when generating, parsing, or manipulating Canonical Type Signatures (CT) โ the compact string representation of data types (primitives, groups, signatures) for RPC/FFI interface descriptions.
Use when defining or consuming a Goโnative (Rust/C++) FFI boundary with FFFI2 (frame-oriented foreign function interface) โ writing the IDL, generating stubs, or using the runtime API.
Use when calling imzero2 Fetcher.Fetch* opcodes โ they must run only from StateManager.Sync() at frame end; calling them inline from a widget or deferred-block body deadlocks the render loop.
Use to learn Leeway fundamentals โ the backbone (plain values) vs payload (tagged values) architecture and basic columnar data modelling.
Use when reading Leeway-encoded data via the stream read-access protocol โ the sink-side read path and membership-role classification.