SQL is a transform-oriented language with 2 major components:
  • DDL for defining database structure.
  • DML for retrieving and updating data.

Until SQL3, SQL did not contain flow of control commands. These had to be implemented using a programming or jobcontrol language, or interactively by the decisions of user.