> For clean Markdown content of this page, append .md to this URL. For the complete documentation index, see https://docs.nvidia.com/heavyai/llms.txt. For full content including API reference and SDK examples, see https://docs.nvidia.com/heavyai/llms-full.txt. # Data Manipulation (DML) #### [SQL Capabilities](/sql/data-manipulation-dml/sql-capabilities) #### [Geospatial Capabilities](/sql/data-manipulation-dml/geospatial-capabilities) #### [Functions and Operators](/sql/data-manipulation-dml/functions-operators) #### [System Table Functions](/sql/data-manipulation-dml/system-table-functions) #### [Window Functions](/sql/data-manipulation-dml/window-functions) #### [Reserved Words](/sql/data-manipulation-dml/omnisci-reserved-words) #### [SQL Extensions](/sql/data-manipulation-dml/sql-extensions) #### [HeavyIQ LLM_TRANSFORM](/sql/data-manipulation-dml/heavyiq-llm_transform) ## Docs - [SQL Capabilities](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities.md) - [ALTER SESSION SET](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/alter-session-set.md) - [ALTER SYSTEM CLEAR](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/alter-system-clear.md) - [DELETE](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/delete.md) - [EXPLAIN](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/explain.md) - [INSERT](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/insert.md) - [KILL QUERY](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/kill-query.md) - [LIKELY/UNLIKELY](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/likely-unlikely.md) - [SELECT](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/select.md) - [SHOW](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/show.md) - [UPDATE](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/update.md) - [Arrays](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/arrays.md) - [Logical Operators and Expressions](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/logical-operators-and-conditional-and-subquery-expressions.md) - [Table Expression and Join Support](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/table-expression-and-join-support.md) - [Type Casts](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-capabilities/type-casts.md) - [Geospatial Capabilities](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/geospatial-capabilities.md) - [Uber H3 Hexagonal Modeling](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/geospatial-capabilities/uber-h3-hexagonal-modeling.md) - [Functions and Operators](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/functions-operators.md): Functions and Operators (DML) - [System Table Functions](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions.md) - [generate_random_strings](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/generate_random_strings.md) - [generate_series](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/generate_series.md) - [tf_compute_dwell_times](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_compute_dwell_times.md) - [tf_feature_self_similarity](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_feature_self_similarity.md) - [tf_feature_similarity](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_feature_similarity.md) - [tf_geo_rasterize](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_geo_rasterize.md) - [tf_geo_rasterize_slope](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_geo_rasterize_slope.md) - [tf_graph_shortest_path](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_graph_shortest_path.md) - [tf_graph_shortest_paths_distances](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_graph_shortest_paths_distances.md) - [tf_load_point_cloud](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_load_point_cloud.md) - [tf_mandelbrot](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_mandelbrot.md) - [tf_point_cloud_metadata](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_point_cloud_metadata.md) - [tf_raster_contour](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_raster_contour_lines-tf_raster_contour_polygons.md) - [tf_raster_graph_shortest_slope_weighted_path](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/system-table-functions/tf_raster_graph_shortest_slope_weighted_path.md) - [Window Functions](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/window-functions.md) - [Reserved Words](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/omnisci-reserved-words.md) - [SQL Extensions](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/sql-extensions.md) - [HeavyIQ LLM_TRANSFORM](https://docs.nvidia.com/heavyai/sql/data-manipulation-dml/heavyiq-llm_transform.md): The LLM_TRANSFORM operator allows you to leverage the power of the HeavyIQ Large Language Model directly from SQL to declaratively specify data transforms using natural language.