Execute SurrealQL queries to interact with SurrealDB databases for complex operations like SELECT with JOINs, schema definitions, transactions, and graph traversals.
Insert multiple records into a SurrealDB table in a single bulk operation. Optimized for efficient data insertion with auto-generated IDs, timestamps, and schema validation.
Replace all fields of a SurrealDB record with new data while preserving ID and timestamps. Use for complete record updates rather than partial modifications.
Permanently remove a database record by its ID, including related graph edges and triggering deletion events. This irreversible operation fails if foreign key constraints exist.
Update specific fields in SurrealDB records using partial data merges. Modify only selected fields while preserving other record data, including nested properties.
Apply JSON Patch operations to modify specific database records using RFC 6902 standard, converting patches to SurrealDB merge operations for compatibility.