query-writing

Write SQL queries for multi-table joins by generating statements with appropriate JOINs, WHERE clauses, and aggregations from user intent. The skill constructs deterministic queries across schemas to retrieve data and generate reports.

Generate SQL from natural language by translating user intent into SELECT statements. The skill writes and executes queries from simple single-table lookups to complex subqueries to retrieve database records.

The query generator validates database schemas via introspection before running. This ensures deterministic query construction by inspecting the schema to confirm table structures and column names before executing the SQL statement.

Retrieve revenue by country across joined tables by generating SQL queries with multi-table JOINs and aggregations. The skill supports generating reports by filtering records and sorting data across different database schemas.

Run a SELECT statement to filter records by instructing the skill to generate and execute the query. It applies to simple lookups or complex aggregations, ensuring clear result presentation for your database reports.