api: "YAML JSON TOON Database"
version: "1.0.0"
format: "json"
dataset:
  id: 18
  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: 0
  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)"