# SQL

- [Data Definition (DDL)](/v8.5.0/sql/data-definition-ddl.md)
- [Datatypes](/v8.5.0/sql/data-definition-ddl/datatypes-and-fixed-encoding.md): Datatypes and Fixed Encoding
- [Users and Databases](/v8.5.0/sql/data-definition-ddl/users-and-databases.md)
- [Tables](/v8.5.0/sql/data-definition-ddl/tables.md)
- [System Tables](/v8.5.0/sql/data-definition-ddl/system-tables.md)
- [Views](/v8.5.0/sql/data-definition-ddl/views.md): DDL - Views
- [Policies](/v8.5.0/sql/data-definition-ddl/policies.md)
- [Comment](/v8.5.0/sql/data-definition-ddl/comment.md)
- [Data Manipulation (DML)](/v8.5.0/sql/data-manipulation-dml.md)
- [SQL Capabilities](/v8.5.0/sql/data-manipulation-dml/sql-capabilities.md)
- [ALTER SESSION SET](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/alter-session-set.md)
- [ALTER SYSTEM CLEAR](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/alter-system-clear.md)
- [DELETE](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/delete.md)
- [EXPLAIN](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/explain.md)
- [INSERT](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/insert.md)
- [KILL QUERY](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/kill-query.md)
- [LIKELY/UNLIKELY](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/likely-unlikely.md)
- [SELECT](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/select.md)
- [SHOW](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/show.md)
- [UPDATE](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/update.md)
- [Arrays](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/arrays.md)
- [Logical Operators and Conditional and Subquery Expressions](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/logical-operators-and-conditional-and-subquery-expressions.md)
- [Table Expression and Join Support](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/table-expression-and-join-support.md)
- [Type Casts](/v8.5.0/sql/data-manipulation-dml/sql-capabilities/type-casts.md)
- [Geospatial Capabilities](/v8.5.0/sql/data-manipulation-dml/geospatial-capabilities.md)
- [Uber H3 Hexagonal Modeling](/v8.5.0/sql/data-manipulation-dml/geospatial-capabilities/uber-h3-hexagonal-modeling.md)
- [Functions and Operators](/v8.5.0/sql/data-manipulation-dml/functions-operators.md): Functions and Operators (DML)
- [System Table Functions](/v8.5.0/sql/data-manipulation-dml/system-table-functions.md)
- [generate\_random\_strings](/v8.5.0/sql/data-manipulation-dml/system-table-functions/generate_random_strings.md)
- [generate\_series](/v8.5.0/sql/data-manipulation-dml/system-table-functions/generate_series.md)
- [tf\_compute\_dwell\_times](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_compute_dwell_times.md)
- [tf\_feature\_self\_similarity](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_feature_self_similarity.md)
- [tf\_feature\_similarity](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_feature_similarity.md)
- [tf\_geo\_rasterize](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_geo_rasterize.md)
- [tf\_geo\_rasterize\_slope](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_geo_rasterize_slope.md)
- [tf\_graph\_shortest\_path](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_graph_shortest_path.md)
- [tf\_graph\_shortest\_paths\_distances](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_graph_shortest_paths_distances.md)
- [tf\_load\_point\_cloud](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_load_point_cloud.md)
- [tf\_mandelbrot\*](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_mandelbrot.md)
- [tf\_point\_cloud\_metadata](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_point_cloud_metadata.md)
- [tf\_raster\_contour\_lines; tf\_raster\_contour\_polygons](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_raster_contour_lines-tf_raster_contour_polygons.md)
- [tf\_raster\_graph\_shortest\_slope\_weighted\_path](/v8.5.0/sql/data-manipulation-dml/system-table-functions/tf_raster_graph_shortest_slope_weighted_path.md)
- [Window Functions](/v8.5.0/sql/data-manipulation-dml/window-functions.md)
- [Reserved Words](/v8.5.0/sql/data-manipulation-dml/omnisci-reserved-words.md)
- [SQL Extensions](/v8.5.0/sql/data-manipulation-dml/sql-extensions.md)
- [HeavyIQ LLM\_TRANSFORM](/v8.5.0/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.