AEM Query Converter
Convert between Query Builder, SQL2, and Java-friendly predicate maps with deterministic validation, explanation, and optimization diagnostics.
🔒 Deterministic conversion and optimization stay local
Your Query Builder to SQL2, SQL2 to Query Builder, validation, explanation, optimization diagnostics, Oak index checks, and Java generation run locally in the browser once the page is loaded. The tool does not require external analysis calls at runtime.
What does this tool do?
Convert between AEM Query Builder parameters and JCR-SQL2 using a normalized AST, then inspect deterministic diagnostics, explanations, and optimization guidance.
How to use it
Choose a conversion direction, paste your Query Builder or SQL2 input, optionally add an Oak index definition, then convert, analyze, explain, or generate Java from the normalized AST.
Supported functionality
path, type, property equality and inequality, fulltext, nodename, boolproperty, rangeproperty, daterange, orderby, p.limit, p.offset, AND and OR groups, nested subgroup expressions, deterministic explanations, optimization diagnostics, Oak index coverage hints, and Query Builder Java map generation within the supported subset.
Limitations
Unsupported predicates or SQL2 expressions are reported explicitly. The tool only generates the supported portion of a query when the remaining expression cannot be represented safely, and optimization guidance remains advisory unless a transformation is provably formatting-safe.
Frequently Asked Questions
The converter distinguishes exact, partial, and unsupported results so it never implies semantic equivalence when a query cannot be represented exactly, and every diagnostic is generated deterministically from the parsed query structure.
Private Browser-Based AEM Query Conversion
Convert, validate, explain, and optimize AEM Query Builder and SQL2 queries directly in your browser. The AEM Query Converter is designed for AEM developers who work with real project queries containing repository paths, metadata properties, and client-specific content structures without depending on external runtime analysis services.