# SQL

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.heavy.ai/v8.3.0/sql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.