# SQL

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