AI2sql-SQL Query Generation

Example

SELECT * FROM transactions WHERE transaction_date BETWEEN '2023-01-01' AND '2023-01-31' AND transaction_amount > 500;

Scenario

A financial analyst needs to review high-value transactions within a specific month to analyze spending trends. AI2sql generates a query to fetch these transactions, simplifying data analysis.

Example

UPDATE customer_details SET email_verified = TRUE WHERE email LIKE '%@example.com';

Scenario

A database administrator needs to update customer records to mark emails from a specific domain as verified. AI2sql crafts the update query, streamlining the database management process.

Example

CREATE TABLE employee (id INT PRIMARY KEY, name VARCHAR(100), position VARCHAR(100), salary DECIMAL);

Scenario

A startup is setting up its employee database and needs to create a table with specific fields. AI2sql generates the SQL command for table creation, aiding in initial database setup.

Example

SELECT department.name, AVG(employee.salary) AS average_salary FROM employee JOIN department ON employee.department_id = department.id GROUP BY department.name;

Scenario

A HR manager wants to understand the average salary by department to make informed compensation decisions. AI2sql composes a query that joins employee and department tables and calculates the average salary per department.