Subset

In SQL, statements are classified by subset. The most known are:

• Data Manipulation Language (DML) (select, update, insert, merge)
• Data Definition Language (DDL) (create, alter, drop)
• Data Control Language (DCL) (grant/revoke)

When parsing a SQL file in SQL mode, you get this information in the subset column.

Note that all SQL statements can not be categorically categorized. For instance, the Sqlite Pragma can:

• get a result with the Sqlite Pragma function
• set parameters PRAGMA analysis_limit = N;

Name

The statement name.

Example of values:

• select
• with
• update
• create

When parsing a SQL file in SQL mode, you get this information in the name column.