[新機能] 入力しながら即座にクエリ結果確認ができるInstant SQLをDuckDB Local UIから試してみた

duckdb -ui

department_id,department_name,location,manager_name
1,Sales,Tokyo,Masashi Sakuma

id,name,department,salary
1,Taro Tanaka,Sales,10
2,Hanako Sato,Development,15
3,Jiro Suzuki,Sales,30
4,Hajime Takenaka,Development,5

SELECT department, AVG(salary) AS avg_salary
FROM 'employees.csv'
GROUP BY department
ORDER BY avg_salary ASC;

SELECT *
FROM employees.csv
WHERE salary <= 10;

WITH dev_employees AS (
  SELECT * FROM employees.csv WHERE department = 'Development'
),
sales_employees AS (
  SELECT * FROM employees.csv WHERE department = 'Sales'
)
SELECT * FROM dev_employees
UNION ALL
SELECT * FROM sales_employees;

Instant SQL does not yet support set operations

WITH dev_employees AS (
SELECT * FROM employees.csv WHERE department = 'Development'
)
SELECT AVG(salary) AS avg_salary_dev
FROM dev_employees;

SELECT * FROM employees.csv
WHERE name LIKE '%Take%';

SELECT e.id, e.name, e.department, d.location
FROM 'employees.csv' as e
JOIN 'departments.csv' as d
  ON e.department = d.department_name;