explain-lpts - Comprehensive reference for the LPTS pipeline.
Provides reference for the LPTS pipeline converting DuckDB logical plans into SQL queries via AST and CTE generation phases.
Tags
Updated: 2026-09-21Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Convert LogicalPlan to AST
- Flatten AST to CTE list
- Serialize CTE list to SQL
- Resolve expressions to SQL strings
- Support DuckDB and Postgres dialects
Inputs
- DuckDB logical plan
- SqlDialect configuration
Outputs
- SQL string with CTEs
- AST tree string representation
Requirements
- DuckDB environment