bucket_wallclock

Generic Description

Is a live Cypher function in Nexyron. It is documented separately because time construction, sequence ordering, window parameters, and as-of behavior materially change analytical meaning.

Simple example:

RETURN bucket_wallclock('day', toZonedDatetime('2026-03-01T12:34:56+02:00'))

Consumer-Level Explanation

Use it when the function semantics match the query intent exactly. Prefer this function when the temporal assumption should be visible to the planner, especially for event streams, freshness checks, and sequence features.

More Detailed Explanation

bucket_wallclock should be understood by the value shape it expects and the row shape it returns. It composes with MATCH, WHERE, WITH, RETURN, and procedure output, so planner-facing documentation should describe both the immediate value transformation and why it belongs in the database query.

Advanced Example

This example names the event stream and operational context before applying bucket_wallclock, which helps planner tooling preserve the intended sequence semantics.

MATCH (coach:Coach)-[e:REVIEWED]->(u:User)
TIME e.ts BETWEEN datetime('2026-03-01T00:00:00Z') AND datetime('2026-03-08T00:00:00Z')
WITH coach,
     u,
     bucket_wallclock('day', e.ts) AS local_day,
     properties(u.profile) AS profile_map
RETURN coach.region AS region,
       local_day,
       count(*) AS reviews,
       avg(size(keys(profile_map))) AS avg_profile_fields
ORDER BY region, local_day

Real Use Cases

• keeping value shaping visible to the planner and reviewers
• combining graph structure with document-style payload handling
• returning named, typed fields that downstream tooling can reason about

Real Limitations And Tradeoffs

• the function does not repair incorrectly modeled input values
• nearby aliases may be clearer if they express the business intent more directly
• broad use inside hot filters should be reviewed for cost and index interaction