Queries

RayforceDB provides powerful query operations for working with Tables. These operations enable you to select, filter, aggregate, modify, and join data efficiently.

Query Operations

Select

Performs data selection, filtering, and aggregation on Tables. Use select to query data, apply filters with where, group with by, and compute aggregations.

Insert

Adds new rows to a Table. You can insert single or multiple rows using lists, dictionaries, or other tables.

Update

Modifies existing columns in Tables. Update specific columns based on conditions using where clauses and optional grouping with by.

Upsert

Updates existing rows or inserts new ones based on key column(s). If a row with the same key exists, it is updated; otherwise, a new row is inserted. Perfect for maintaining unique records.

Alter

Modifies elements at specific indices in Vectors, Lists, or Tables using functions.

Joins

Combine rows from two Tables based on matching column values. Join operations enable you to merge related data from different tables.

Available Join Types:

• Left Join: Keeps all rows from the left table and matching rows from the right table. Missing matches are filled with null values.

• Inner Join: Keeps only rows where join columns match in both tables. Returns the intersection of both tables.

• Window Join: Joins tables based on equality for all join columns except the last one, using time windows for the last column. Ideal for time-series data analysis.