> ## Documentation Index
> Fetch the complete documentation index at: https://docs.levelblue.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Queries

USM Anywhere supports queries written in Structured Query Language (SQL). For syntax guidance, refer to the following:

* [OpenSearch SQL Basic Queries](https://docs.opensearch.org/latest/search-plugins/sql/sql/basic/)
* [OpenSearch SQL Complex Queries](https://docs.opensearch.org/latest/search-plugins/sql/sql/complex/)

### Supported SQL clauses

The following SQL clauses are supported in custom queries:

* SELECT (required)
* FROM (required)
* WHERE
* GROUP BY
* ORDER BY
* LIMIT
* Wildcard (\*)

### Unsupported SQL clauses

The following SQL features are not supported:

* JOINS statements
* Nested SELECTS statements

### SQL query example

<Frame>
  <img src="https://mintcdn.com/levelblue-5324744e/NfRKlZ9BkswRFp4P/images/usm-anywhere/SQL.png?fit=max&auto=format&n=NfRKlZ9BkswRFp4P&q=85&s=be94f59b9783379e1fb03f949c7a159f" alt="" width="1146" height="248" data-path="images/usm-anywhere/SQL.png" />
</Frame>