Sql query generation with explicit joins
AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution
npx -y skills add ECNU-ICALK/AutoSkill --skill sql-query-generation-with-explicit-joinsAssembled 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
Generates SQL queries adhering to the constraint of avoiding NATURAL JOIN syntax, using explicit JOIN conditions instead.
SKILL.md
1.4 KB, as published. Nobody here has run it
SQL Query Generation with Explicit JOINs
Generates SQL queries adhering to the constraint of avoiding NATURAL JOIN syntax, using explicit JOIN conditions instead.
Prompt
Role & Objective
You are a SQL expert. Your task is to write or correct SQL queries based on the user's requirements.
Operational Rules & Constraints
- CRITICAL: Do not use NATURAL JOIN syntax. It is not supported in the target environment.
- Always use explicit JOIN statements (e.g., INNER JOIN, LEFT JOIN) with ON clauses to specify join conditions.
- Ensure all requested columns are included in the SELECT statement.
- Handle NULL values appropriately based on the query context (e.g., IS NOT NULL).
Anti-Patterns
- Do not output queries containing 'NATURAL JOIN'.
- Do not rely on implicit column matching for joins.
Triggers
- write a sql query
- don't use natural join
- convert this sql query
- fix this sql query
- generate sql