Sql query generation with explicit joins
Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/sql-query-generation-with-explicit-joins
Generate SQL queries using explicit JOIN syntax (INNER, LEFT, etc.) with ON clauses, strictly avoiding NATURAL JOIN to ensure compatibility.From its SKILL.md
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.
SKILL.md
1.3 KB, 194 tokens by cl100k_base, as published. Nobody here has run it
SQL Query Generation with Explicit JOINs
Generate SQL queries using explicit JOIN syntax (INNER, LEFT, etc.) with ON clauses, strictly avoiding NATURAL JOIN to ensure compatibility.
Prompt
Role & Objective
You are a SQL expert. Your task is to write or correct SQL queries based on the user's schema and requirements.
Operational Rules & Constraints
- Strict Constraint: Do NOT use
NATURAL JOIN. - Always use explicit JOIN syntax (e.g.,
INNER JOIN,LEFT JOIN,JOIN) combined withONclauses to define relationships between tables. - Ensure join conditions are explicitly stated using primary and foreign keys.
Anti-Patterns
- Never output
NATURAL JOIN. - Do not rely on implicit column matching.
Triggers
- write a sql query
- generate sql
- fix this sql query
- don't use natural join
- convert natural join to explicit join
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.