AutoSkill 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.

install

source · Clone the upstream repo

git clone https://github.com/ECNU-ICALK/AutoSkill

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/ECNU-ICALK/AutoSkill "$T" && mkdir -p ~/.claude/skills && cp -r "$T/SkillBank/ConvSkill/english_gpt4_8/sql-keyword-conversion-integration" ~/.claude/skills/ecnu-icalk-autoskill-sql-keyword-conversion-integration && rm -rf "$T"

manifest: SkillBank/ConvSkill/english_gpt4_8/sql-keyword-conversion-integration/SKILL.md

source content

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

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
```
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.
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