SurrealQL is the query language for SurrealDB. It closely resembles traditional SQL, with some differences and improvements.
SurrealQL is designed to provide developers with an intuitive way to interact with SurrealDB. It offers a familiar syntax and supports various statement types, allowing you to perform complex database operations efficiently.
While SurrealQL shares similarities with traditional SQL, it introduces enhancements and optimisations that make it well-suited for working with SurrealDB's advanced features. The same language is used to query data, modify records and manage database structures.
Key features
The main features of SurrealQL are:
Familiar syntax: SurrealQL adopts a syntax similar to traditional SQL, so developers who know SQL can start using SurrealDB with little relearning.
Advanced querying: SurrealQL supports a wide range of querying capabilities, including filtering, sorting, aggregating, and joining data from multiple tables.
Data manipulation: SurrealQL has statements to insert, update, and delete records in your SurrealDB database.
Graph relationships: SurrealQL supports graph relationships, allowing you to define and query relationships between records in your database.
Schema management: SurrealQL provides features for creating and modifying database schemas, allowing you to define the structure of your data and enforce data integrity.
Performance optimisation: SurrealQL incorporates optimisations specific to SurrealDB, ensuring efficient execution of queries and minimising resource usage.
