---
id: "03767f2b-fcd3-4a7e-8916-a1a49e62f670"
name: "SQL Keyword Conversion Integration"
description: "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."
version: "0.1.0"
tags:
  - "python"
  - "sql"
  - "query parsing"
  - "keyword mapping"
  - "data processing"
triggers:
  - "integrate convert keywords"
  - "modify query executor to convert keywords"
  - "add keyword mapping to sql parser"
  - "convert fetch put remove merge filter to sql"
---

# 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