Module patterns

Module patterns 

Source
Expand description

Helper functions for common CTE patterns.

Functionsยง

graph_path
Create a recursive CTE for graph path finding.
paginated
Create a CTE for pagination (row numbering).
running_total
Create a CTE for running totals.
tree_traversal
Create a recursive CTE for tree traversal (parent-child hierarchy).