Query Analytical Engine

Use this skill when executing in-process analytical queries, orchestrating multi-step analytical pipelines, or federating queries across disparate data sources without heavy ETL. For production lakehouse schema design and storage tuning, use optimize-olap-database instead.

When to Use

• running sub-second analytical queries directly in-process via embedded chDB or DuckDB v1.5+
• orchestrating multi-step analytical pipelines and temporary session state using chdb.session.Session
• federating queries and joins across S3 Parquet, PostgreSQL, MySQL, and Apache Iceberg without ETL jobs
• transferring in-memory tabular datasets zero-copy via the Apache Arrow C Data Interface
• calculating analytical window functions, moving averages, quantiles, and aggregate state combinators
• validating and hardening AI-generated analytical SQL statements via sqlglot AST parsing
• enforcing read-only connection isolation, connection pooling governance, and execution timeout ceilings

Core Rules