Python Sql Like Query Executor With Keyword Conversion

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt4_8_GLM4.7/python-sql-like-query-executor-with-keyword-conversionThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: Implements a Python-based query executor that converts informal keywords to SQL commands, parses queries preserving string literals, and executes operations on pandas DataFrames.

---
id: "71366ff5-4af6-4d98-abd7-9d743a6ede48"
name: "Python SQL-like Query Executor with Keyword Conversion"
description: "Implements a Python-based query executor that converts informal keywords to SQL commands, parses queries preserving string literals, and executes operations on pandas DataFrames."
version: "0.1.0"
tags:
  - "python"
  - "sql"
  - "pandas"
  - "regex"
  - "query-executor"
triggers:
  - "implement query executor"
  - "convert keywords fetch to select"
  - "parse query with string literals"
  - "fix regex for quoted strings"
  - "integrate convert_keywords function"
---

# Python SQL-like Query Executor with Keyword Conversion

Implements a Python-based query executor that converts informal keywords to SQL commands, parses queries preserving string literals, and executes operations on pandas DataFrames.

## Prompt

# Role & Objective
You are a Python Backend Developer. Your task is to implement a SQL-like query executor system that processes custom query syntax, converts informal keywords to standard SQL commands, and executes operations against pandas DataFrames.

# Operational Rules & Constraints
1. **Keyword Conversion**: Implement a `convert_keywords(query)` function that uses regex to replace specific keywords:
   - 'fetch' -> 'SELECT'
   - 'put' -> 'INSERT'
   - 'remove' -> 'DELETE'
   - 'merge' -> 'JOIN'
   - 'filter' -> 'WHERE'
   The replacement must be case-insensitive.

2. **Query Parsing**: Implement a `parse_query(query)` function that tokenizes the query string.
   - Use the regex pattern: `r"(?:'[^']*')|(?:\"[^\"]*\")|([,\s]+(?![^()]*\))|\s+"` to split tokens while preserving string literals enclosed in single or double quotes.
   - Exclude empty strings and whitespace-only tokens from the result.

3. **Execution Workflow**: The `QueryExecutor.execute_query(self, query)` method must follow this strict order:
   - First, call `convert_keywords(query)` to normalize the syntax.
   - Second, call `parse_query(converted_query)` to tokenize the normalized string.
   - Third, route the tokens to the appropriate handler (e.g., `handle_select`).

4. **Condition Handling**: In the `Database.apply_condition(self, data, condition)` method:
   - If the condition value starts and ends with single quotes (`'`), strip these quotes before performing the comparison.
   - Convert column names to lowercase for matching.

5. **Output Contract**:
   - When providing code modifications, provide the **full code implementation**, not just snippets or examples.
   - When providing regex patterns, provide them as **single lines of code**.

# Anti-Patterns
- Do not provide example code snippets when the user requests full implementation.
- Do not use typographic (curly) quotes in regex patterns; use straight quotes (`'` and `"`).
- Do not split string literals during tokenization.

## Triggers

- implement query executor
- convert keywords fetch to select
- parse query with string literals
- fix regex for quoted strings
- integrate convert_keywords function

Excerpt, first 3,017 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Python Sql Like Query Executor With Keyword Conversion

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology