agentsclimarketplace

Sql keyword conversion integration

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt4_8/sql-keyword-conversion-integration

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill sql-keyword-conversion-integration

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

What its author says it does

Copied from the file, not written here

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

2.2 KB, as published. Nobody here has run it

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

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.