{
    "api": "YAML JSON TOON Database",
    "version": "1.0.0",
    "format": "json",
    "dataset": {
        "id": 491,
        "slug": "sql-query-types",
        "title": "SQL Query Types Reference",
        "description": "Categories of SQL statements for data definition, manipulation, and control.",
        "category": "Database Types",
        "category_slug": "database-types",
        "tags": "sql,database,query,reference",
        "view_count": 1,
        "created_at": 1781275786,
        "updated_at": 1781275786
    },
    "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)"
            }
        ]
    }
}