@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix register: <https://knobit.org/id/register/> .
@prefix schema: <https://schema.org/> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .

knobit:K-811 a edu:Knobit ;
    rdfs:label "Recognises a reserved word used as an identifier"@en ;
    dcterms:identifier "K-811" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    dcterms:source "Review checklist 05-ddl, row 11; ISO 9075; this skill"@en ;
    skos:altLabel "Reserved word as an identifier (generated DDL)"@en ;
    skos:definition "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."@en ;
    skos:prefLabel "Recognises a reserved word used as an identifier"@en ;
    edu:actionVerb "Recognises"@en ;
    edu:appliesKnowledge knobit:K-852,
        knobit:K-919 ;
    edu:assessmentCriterion "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`)"@en ;
    edu:assessmentMethod "skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills)"@en ;
    edu:contextFunction <https://knobit.org/def/contextFunction/resultEvaluation> ;
    edu:creationMethod <https://knobit.org/def/creationMethod/aiGeneratedHumanEdited> ;
    edu:expectedResult "The name, the engine reserving it and its replacement"@en ;
    edu:graphRelevance <https://knobit.org/def/graphRelevance/learnerState>,
        <https://knobit.org/def/graphRelevance/taskSelection> ;
    edu:knobitType <https://knobit.org/def/knobitType/skill> ;
    edu:targetObject "table or column name"@en ;
    schema:creativeWorkStatus "accepted" ;
    schema:isPartOf register:data-modelling .

edu:Knobit rdfs:label "Knobit"@en,
        "Knobit"@et .

knobit:K-852 rdfs:label "Explains SQL dialect differences"@en .

knobit:K-919 rdfs:label "Explains naming conventions for data model objects"@en .