Comparing DQL and SQL Modes › Selecting a Mode › Advantages

Advantages

Note the following list of advantages for DQL Mode and SQL Mode.

DQL Mode:

• Permits outer joins.
• Allows 18-digit precision.
• Handles more data types than SQL.
• Reads all accessible data in all tables.
• Can be translated into other languages.
• Has field level and content security without views.
• Queries can be executed in stages and re-executed starting at any stage.
• Offers a catalogued reusable syntax (terms) for use in queries.
• Supports the relational equijoin.
• Saves pointers to retrieved data that can be reused (saved sets).

SQL Mode:

• Allows a table to be related to itself.
• Allows nested SUBSELECTs.
• Supports full relational joins.
• Supports views.
• Supports the dynamic creation and dropping of tables.
• Supports the creation of summarization rows.
• Supports a test for existence, for instance, has complete null support.
• Supports data selection based on column functions.