HyperQuery™ Resources Documentation

Documentation

Documentation and guides for HyperQuery™ and ASTRO™.

Getting Started with HyperQuery™

A step-by-step guide to creating your account, adding a payment method, and running your first query optimization. Includes tips on choosing source and target dialects, interpreting the ASTRO™ rewrite report, and downloading PerfectSQL™ output.

Understanding the ASTRO™ Rewrite Report

Detailed documentation of the rewrite report output: rules fired, fixpoint iterations, structural diff metrics (AST nodes, max depth, predicates, func-wrapped columns), and how to interpret the before/after SQL comparison.

Supported SQL Dialects Reference

Complete reference guide for all 17 supported SQL dialects — ANSI, BigQuery, ClickHouse, Databricks, DuckDB, Hive, MySQL, Oracle, PostgreSQL, Presto, Amazon Redshift, Snowflake, Apache Spark SQL, SQLite, StarRocks, Trino, and SQL Server (T-SQL).

CNF and DNF Normal Forms in ASTRO™

Technical documentation explaining Conjunctive Normal Form (AND of ORs) and Disjunctive Normal Form (OR of ANDs) in the context of SQL WHERE clause optimization, including when each form benefits different database optimizer strategies.