# SQL

_This page explains what SQL support in KDB-X is and how it works._

SQL provides a familiar relational interface for querying and managing data in KDB-X, allowing users to leverage standard SQL syntax within the q environment.

## Concepts

SQL in KDB-X combines ANSI SQL familiarity with the power of the q interface.  

- **Translation layer**: The interface translates SQL statements into q expressions at runtime.
- **ANSI SQL alignment**: SQL in KDB-X implements a subset of [ANSI SQL features](reference.md#sql-compliance)
- **Data integration**: You can run SQL and q queries on the same data in the same session.

## Use cases

SQL in KDB-X helps different users work with data efficiently.  

- Query relational-style data in KDB-X with SQL.
- Onboard SQL developers quickly without requiring q knowledge.
- Prototype queries in SQL before rewriting or optimizing them in q.

## Architecture

The SQL interface in KDB-X parses, translates, and executes SQL statements against q data.  

- The SQL parser reads and interprets SQL commands.
- The interface converts SQL into q at runtime.
- The system raises errors when you use unsupported syntax.

## SQL language support

SQL in KDB-X supports a wide range of common SQL features:

- [Operators](reference.md#operators)  
- [Functions](reference.md#functions)  
- [Data and literals](reference.md#data-and-literals)  
- [Select statements](reference.md#select-statements)  
- [Table creation, modification, and deletion](quickstart.md)

## Next steps

- Check how the SQL interface is installed, and how to update it, in [Install and update SQL](install.md).
- Follow the [Quickstart](quickstart.md) to create and query tables.
- Explore the [Reference](reference.md) page for full operator and function details.
- Refer to [examples](examples.md) for practical queries and workflows.
- Check the [SQL Release Notes](./release-notes/changelog.md) for version history and fixes.
