Standard Query Language (SQLY)

SQLY is a YAML-based query language inspired by JQL, Kusto, and DQL. It is designed for querying structured and semi-structured data efficiently.

📖 Specification Overview

🔹 Basics

Learn how to write simple SQLY queries, including select, from, where, order_by, and group_by.

🔹 Advanced Features

Explore complex filtering, logical operators, sorting, and aggregations.

🔹 Subqueries

Use subqueries to fetch results dynamically within a query.

🔹 Common Table Expressions (CTEs)

Utilize CTEs to structure queries for better readability and performance.

🔹 Window Functions

Perform ranking, running totals, and moving averages using window functions.

🔹 Recursive Queries

Handle hierarchical data, such as employee relationships or category trees.

🔹 Full-text Search

Perform fuzzy searches and text matching in large datasets.

🔹 Geospatial Queries

Work with geospatial data to find points within a radius, bounding boxes, and distances.

🔹 Machine Learning

Integrate predictive models for forecasting and anomaly detection within queries.

🔹 JSON & Arrays

Filter and manipulate JSON fields and array data types.

🔹 User-defined Functions (UDFs)

Define and use custom functions to extend SQLY’s capabilities.

🔹 Performance Optimization

Learn techniques to optimize query execution and improve efficiency.

🔹 Advanced Debugging

Enable query tracing, logging, and error handling for efficient debugging.

🔹 SQLY Extensions

Explore custom functions, external data sources, and event-driven triggers.

🚀 Getting Started

To start using SQLY, check out the Basics section and explore examples.

📌 Contributions

Contributions are welcome! Feel free to submit PRs or issues for improvements.

📜 License

This project is licensed under the MIT License.