// EXECUTION_PIPELINE

Implementation Pipeline

Our engine handles the complexity of data movement while you focus on high-level decision logic.

PHASE_1 // Geographic Analysis

Create a report of all orders over $100 in California that used the code SUMMER20, grouped by city.

PHASE_2 // Fulfillment Auditing

Show me all unfulfilled orders older than 5 days, grouped by shipping country.

PHASE_3 // Discount Auditing

Break down last month’s revenue by specific discount codes used, including the total COGS.

// STRATEGIC_SCENARIO

Deep Data Retrieval

How Arcli grounds AI in your exact schema to generate highly-optimized, dialect-specific execution logic.

The Engine Room: Natural Language to SQL

How Arcli converts an English request into a structured geographic discounting report.

THE EXECUTIVE FILTER (ROI)

Empowers non-technical operators to interrogate their data directly, removing the analytics bottleneck.

  • Fully optimized for DuckDB SQL constraints.
  • Bypasses semantic layer hallucinations via strict schema grounding.
DuckDB SQL_COMPILE
-- User Prompt: "Revenue by California city where SUMMER20 was used"
SELECT 
    shipping_address_city AS city,
    COUNT(id) AS total_orders,
    SUM(total_price) AS gross_revenue,
    SUM(total_discounts) AS discount_amount
FROM tenant_workspace.shopify.orders
WHERE shipping_address_province = 'California'
  AND discount_codes LIKE '%SUMMER20%'
  AND created_at >= DATE_TRUNC('month', CURRENT_DATE)
GROUP BY 1
ORDER BY gross_revenue DESC;