> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/gridgain/gridgain-8/reference/sql.md).

# SQL Reference

A comprehensive reference to the SQL data types, functions, commands, and conformance information supported by GridGain.

A comprehensive list of the supported SQL data types, functions, and other commands and information for GridGain, including:

{% columns %}
{% column %}
{% content-ref url="/pages/6yCmT0i6UBtliTONIUAe" %}
[SQL Conformance](/docs/gridgain/gridgain-8/reference/sql/sql-conformance.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
GridGain and Apache Ignite conformance to the ANSI SQL:1999 (Core) standard, broken down by feature and sub-feature support.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/J8PaXh01O3jSFbN6och6" %}
[Data Definition Language (DDL)](/docs/gridgain/gridgain-8/reference/sql/ddl.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of the SQL Data Definition Language (DDL) commands supported by GridGain — CREATE/ALTER/DROP TABLE, indexes, users, and statistics commands.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/pkCWuABpFPk8hbGMsWJf" %}
[Data Manipulation Language (DML)](/docs/gridgain/gridgain-8/reference/sql/dml.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of the SQL Data Manipulation Language (DML) commands supported by GridGain — SELECT, INSERT, UPDATE, WITH, MERGE, and DELETE.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/pdAXDlIMOkHLbOww6IcC" %}
[Transactions](/docs/gridgain/gridgain-8/reference/sql/transactions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
SQL transaction control in GridGain using BEGIN, COMMIT, and ROLLBACK statements.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/vBEJIWr7nHslCywrLuOA" %}
[Operational Commands](/docs/gridgain/gridgain-8/reference/sql/operational-commands.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of GridGain SQL operational commands — COPY INTO, SET STREAMING, KILL QUERY, KILL CONTINUOUS, and the legacy COPY command.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/GJEINgsaHU0G8WAOFOac" %}
[Functions](/docs/gridgain/gridgain-8/reference/sql/functions.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The SQL functions supported by GridGain 8, grouped by category — aggregate, numeric, string, date and time, JSON, and system functions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Co6p7CqRVFnxp2e945Sm" %}
[Data Types](/docs/gridgain/gridgain-8/reference/sql/data-types.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Reference of the SQL data types available in GridGain — boolean, numeric, string, date/time, and binary types — and their language and driver mappings.
{% endcolumn %}
{% endcolumns %}