Recognises a reserved word used as an identifier
A table or column name that is reserved on one of the configured targets. It can quote cleanly on four engines and fail on the fifth, or deploy everywhere and break the first hand-written query.
Can AI do this?
Not tested yet
No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.
What it looks like in practice
Expected result: The name, the engine reserving it and its replacement
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: A dim_party column named current for the current relationship owner: reserved in ISO 9075 and in Postgres Acceptable: is_current_relationship, with the reserved-word check run against every configured dialect rather than only the development one (PHY-012)
Also known as: Reserved word as an identifier (generated DDL)
Related knobits
Builds on
All 33 knobits of Generate and review DDL.
Source: Review checklist 08-ddl, row 11; ISO 9075; this skill