{
    "api": "YAML JSON TOON Database",
    "version": "1.0.0",
    "format": "json",
    "dataset": {
        "id": 2493,
        "slug": "sql-query-types",
        "title": "SQL Query Types Reference",
        "description": "Categories of SQL statements for data definition, manipulation, and control.",
        "summary": "The SQL statement categories: DDL for schema, DML for changing data, DCL for permissions, TCL for transactions and DQL for queries, each with its full name, the statements it contains and its purpose.",
        "use_when": [
            "You need to classify a SQL statement or explain the categories to a newcomer.",
            "You are setting permissions by statement category."
        ],
        "caveats": [
            "Some sources fold SELECT into DML and omit DQL as a separate category.",
            "Which statements are transactional differs by database; DDL is auto-committed in some systems and transactional in others."
        ],
        "related": [
            "sql-join-types",
            "acid-vs-base",
            "database-comparison"
        ],
        "entry_count": 5,
        "fields": [
            {
                "section": "query_types",
                "field": "category",
                "type": "string",
                "example": "DDL"
            },
            {
                "section": "query_types",
                "field": "full_name",
                "type": "string",
                "example": "Data Definition Language"
            },
            {
                "section": "query_types",
                "field": "statements",
                "type": "string",
                "example": "CREATE, ALTER, DROP, TRUNCATE"
            },
            {
                "section": "query_types",
                "field": "purpose",
                "type": "string",
                "example": "Define and modify database schema"
            }
        ],
        "category": "Database Types",
        "category_slug": "database-types",
        "tags": "sql,database,query,reference",
        "view_count": 57,
        "created_at": 1777673262,
        "updated_at": 1777673262
    },
    "data": {
        "query_types": [
            {
                "category": "DDL",
                "full_name": "Data Definition Language",
                "statements": "CREATE, ALTER, DROP, TRUNCATE",
                "purpose": "Define and modify database schema"
            },
            {
                "category": "DML",
                "full_name": "Data Manipulation Language",
                "statements": "SELECT, INSERT, UPDATE, DELETE",
                "purpose": "Query and modify data"
            },
            {
                "category": "DCL",
                "full_name": "Data Control Language",
                "statements": "GRANT, REVOKE",
                "purpose": "Manage user permissions"
            },
            {
                "category": "TCL",
                "full_name": "Transaction Control Language",
                "statements": "COMMIT, ROLLBACK, SAVEPOINT",
                "purpose": "Manage database transactions"
            },
            {
                "category": "DQL",
                "full_name": "Data Query Language",
                "statements": "SELECT",
                "purpose": "Query data (subset of DML)"
            }
        ]
    }
}