Writing database queries
Authoring and tuning SQL and analytical queries.
Task automation exposure
Very high exposure
Exposure basis
[v3/median] score 85 (A 85 / B 95 / C 70, spread 25) Current AI models (e.g., GPT‑4, Codex, Copilot) can generate correct SQL, rewrite queries for performance, and suggest indexes or plan optimizations at a level a professional would accept, though occasional edge‑case review may be needed. (capable: OpenAI GPT‑4 (code generation) / GitHub Copilot)
2 capabilities · 0 occupations
Basis
How exposure was assessed
[v3/median] score 85 (A 85 / B 95 / C 70, spread 25) Current AI models (e.g., GPT‑4, Codex, Copilot) can generate correct SQL, rewrite queries for performance, and suggest indexes or plan optimizations at a level a professional would accept, though occasional edge‑case review may be needed. (capable: OpenAI GPT‑4 (code generation) / GitHub Copilot)
How much of this task's output current AI can produce or substantially assist.
Best current model strength on any capability this task requires.
This is an assessment of technical feasibility plus published evidence - not a forecast. Even fully automatable tasks are often not automated, because of cost, verification, liability, regulation or the fact that the task is bundled with other work.
Capabilities
AI capabilities involved
- Code82
12 models tracked · strongest: Claude Opus 5.5
15 models tracked · strongest: GPT-5
Occupations
Occupations that perform this task (0)
Importance is the O*NET-style weight of this task within each occupation. The same task can be highly exposed but peripheral to one job and core to another.
| Occupation | Industry | Importance | Role | Occupation AI exposure |
|---|
Evidence
Evidence (0)
No evidence item is mapped to this specific task yet. The exposure figure above rests on the v1 editorial baseline and on the capability assessment, and should be treated as low-confidence. Pages with fewer than 0 evidence items are excluded from sitemaps.