Database Operations

This section covers Rell's database operations, including creating, updating, and deleting records with various options and syntax.

Overview

Learn about Rell's record notations for creating and managing database entries, using the @ operator for querying, and performing advanced operations like joins and data aggregation.

Create statement

Use the create statement to add new records, specify non-default attributes, and simplify assignments with variables. It supports batch insertions and returns a list of inserted entities.

Update statement

Update records with cardinality operators (@, @?, @*, @+) to modify only mutable attributes. Implicit matching by name or type is supported, and single attributes can be changed using regular assignment.

Delete statement

Delete records with cardinality operators (@, @?, @*, @+) to indicate how many records to remove. You can use entity expressions for precise deletion and include multiple entities in the where-part.