explain-lpts-ddl

What problem does it solve?

This skill solves the problem of needing to manually search source code or external resources to correctly use the LPTS DuckDB extension's features for SQL transpilation, logical plan inspection, and query validation.

Core Features & Use Cases

• Complete DDL Reference: Covers all LPTS pragmas (PRAGMA lpts, lpts_exec, lpts_check, print_ast), table functions (lpts_query), and dialect configuration settings.
• Cross-System SQL Transpilation Support: Includes documentation for converting DuckDB queries to PostgreSQL, Spark SQL, BigQuery, and other supported dialects.
• Use Case: A data engineer can use this skill to quickly look up the correct syntax for PRAGMA lpts_check to validate that transpiled SQL returns identical results to the original query, or use print_ast to debug logical plan conversion issues.

Quick Start

Use the explain-lpts-ddl skill to look up the correct syntax for PRAGMA lpts_check and verify that your transpiled SQL produces the same results as the original query.