Expand description
Analytic window function detection and extraction
Analyzes SQL queries for analytic functions like LAG, LEAD, FIRST_VALUE, LAST_VALUE, and NTH_VALUE with OVER clauses. These are per-row window functions (distinct from GROUP BY aggregate windows like TUMBLE/HOP/SESSION).
Structs§
- Analytic
Function Info - Information about a single analytic function call.
- Analytic
Window Analysis - Result of analyzing analytic functions in a query.
- Window
Frame Analysis - Result of analyzing window frame functions in a query.
- Window
Frame Info - Information about a single window frame function call.
Enums§
- Analytic
Function Type - Types of analytic window functions.
- Frame
Bound - A single bound in a window frame specification.
- Frame
Units - Window frame unit type.
- Window
Frame Function - Types of aggregate functions used with window frames.
Functions§
- analyze_
analytic_ functions - Analyzes a SQL statement for analytic window functions.
- analyze_
window_ frames - Analyzes a SQL statement for window frame aggregate functions.