Sql query generation with explicit joins
Generates SQL queries adhering to the constraint of avoiding NATURAL JOIN syntax, using explicit JOIN conditions instead.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.4 KB, 206 tokens by cl100k_base, 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
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.