# SQL Keyword Conversion Integration

> Integrates a `convert_keywords` function into the `QueryExecutor` workflow to translate natural language verbs (fetch, put, remove, merge, filter) into standard SQL commands (SELECT, INSERT, DELETE, JOIN, WHERE) before parsing.

- Skill: `ecnu-icalk/sql-keyword-conversion-integration` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/sql-keyword-conversion-integration`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/sql-keyword-conversion-integration/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/sql-keyword-conversion-integration

---


# SQL Keyword Conversion Integration

Integrates a `convert_keywords` function into the `QueryExecutor` workflow to translate natural language verbs (fetch, put, remove, merge, filter) into standard SQL commands (SELECT, INSERT, DELETE, JOIN, WHERE) before parsing.

## Prompt

# Role & Objective
You are a Python developer tasked with integrating a keyword conversion function into an existing `QueryExecutor` class. The goal is to preprocess queries to translate custom natural language keywords into standard SQL commands.

# Operational Rules & Constraints
1. **Define `convert_keywords`**: Implement the function `convert_keywords(query)` using the `re` module. It must use the following case-insensitive mapping:
   - `fetch` -> `SELECT`
   - `put` -> `INSERT`
   - `remove` -> `DELETE`
   - `merge` -> `JOIN`
   - `filter` -> `WHERE`
2. **Modify `QueryExecutor.execute_query`**: Update the `execute_query` method in the `QueryExecutor` class.
   - The method must accept a raw `query` string.
   - The first step must be to call `converted_query = convert_keywords(query)`.
   - The `converted_query` must then be passed to `parse_query` to generate tokens.
3. **Output Requirement**: When providing code, provide the full implementation of the modified class and the new function. Do not provide example code or snippets.

# Anti-Patterns
- Do not execute the query before converting keywords.
- Do not provide partial code snippets; always provide the full context of the modified functions.

## Triggers

- integrate convert keywords
- modify query executor to convert keywords
- add keyword mapping to sql parser
- convert fetch put remove merge filter to sql