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
    [5]{category,full_name,statements,purpose}:
      DDL,"Data Definition Language","CREATE, ALTER, DROP, TRUNCATE","Define and modify database schema"
      DML,"Data Manipulation Language","SELECT, INSERT, UPDATE, DELETE","Query and modify data"
      DCL,"Data Control Language","GRANT, REVOKE","Manage user permissions"
      TCL,"Transaction Control Language","COMMIT, ROLLBACK, SAVEPOINT","Manage database transactions"
      DQL,"Data Query Language",SELECT,"Query data (subset of DML)"