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