queryilla

Queryilla is a domain-specific query language and execution engine designed for exploring structured data, reporting, and lightweight analytics. It emphasizes readability and portability, aiming to make complex data queries accessible without extensive programming.

Queryilla originated within a community-driven project developed by data engineers and researchers who sought to bridge the gap between traditional SQL and modern analytics workloads. The first public release appeared in 2021, with ongoing development maintained through an open-source repository and community contributions. The project provides a reference implementation and an ecosystem of adapters for common storage systems.

Key features include a SQL-like syntax extended with natural-language-inspired constructs for filtering and shaping results, plan optimization and cost-based optimization, support for joins, aggregations, window functions, and temporal queries, and a modular architecture that allows pluggable backends (such as relational databases, columnar stores, and streaming sources). It supports multi-database queries, role-based access control, caching, and parallel execution.

Usage example: A query might look like: SELECT country, AVG(sales) AS average_sales FROM orders WHERE date >= '2023-01-01' GROUP BY country ORDER BY average_sales DESC; This illustrates the emphasis on familiar syntax combined with analytics-oriented extensions.

Adoption and ecosystem tend to be strongest among mid-sized organizations and research projects, with both community and enterprise editions and a growing set of connectors and tooling. The project emphasizes open standards, documentation, and interoperability with existing SQL-based workflows.