SQL Extensions

SQL extensions provide small, declarative utilities that simplify common graph‑building tasks in the Relationship Visualizer.

Each extension is activated by passing specific values as SQL parameters, enabling expressive diagrams with minimal query logic.

Use the cards below to explore each extension.

Directives

Lightweight commands that enable optional behaviors within the SQL pipeline. Group Nodes into Nested Clusters

Group related rows into clusters or subclusters to visually organize sections of your graph. Split Long Label Text

Split long text labels into multiple lines for improved readability. Align Nodes on the Same Level

Wrap selected nodes into ranked subgraphs to control layout, alignment, and visual grouping. Generate Edges to Chain Nodes

Generate edges between sequential nodes to create simple chains—useful for timelines or ordered flows. Traverse Trees Recursively

Use recursive SQL to walk hierarchical data and produce parent‑child structures such as organization charts. Iterate SQL Results

Iterate over SQL query results to execute a follow‑up query using the initial results. Enumerate Values

Assign incremental numbers to rows for ordering, labeling, or sequence‑based logic. Substitute Counts

Automatically substitute cluster, subcluster, and row counts into labels and sorting attributes. Concatenate Values

Combine multiple fields or computed values into a single label, often used together with iteration.