Features

1-- Add a graph edge between user:tobie and article:surreal
2RELATE user:tobie->write->article:surreal
3	SET time.written = time::now()
4;
5
6-- Add a graph edge between specific users and developers
7LET $from = (SELECT users FROM company:surrealdb);
8LET $devs = (SELECT * FROM user WHERE tags CONTAINS 'developer');
9RELATE $from->like->$devs UNIQUE
10	SET time.connected = time::now()
11;

1-- Select a nested array, and filter based on an attribute
2SELECT emails[WHERE active = true] FROM person;
3
4-- Select all 1st, 2nd, and 3rd level people who this specific person record knows, or likes, as separate outputs
5SELECT ->knows->(? AS f1)->knows->(? AS f2)->(knows, likes WHERE influencer = true AS e3)->(? AS f3) FROM person:tobie;
6
7-- Select all person records (and their recipients), who have sent more than 5 emails
8SELECT *, ->sent->email->to->person FROM person WHERE count(->sent->email) > 5;
9
10-- Select other products purchased by people who purchased this laptop
11SELECT <-purchased<-person->purchased->product FROM product:laptop;
12
13-- Select products purchased by people in the last 3 weeks who have purchased the same products that we purchased
14SELECT ->purchased->product<-purchased<-person->(purchased WHERE created_at > time::now() - 3w)->product FROM person:tobie;

1-- Select all person records with IDs between the given range
2SELECT * FROM person:1..1000;
3-- Select all records for a particular location, inclusive
4SELECT * FROM temperature:['London', NONE]..=['London', time::now()];
5-- Select all temperature records with IDs less than a maximum value
6SELECT * FROM temperature:..['London', '2022-08-29T08:09:31'];
7-- Select all temperature records with IDs greater than a minimum value
8SELECT * FROM temperature:['London', '2022-08-29T08:03:39']..;
9-- Select all temperature records with IDs between the specified range
10SELECT * FROM temperature:['London', '2022-08-29T08:03:39']..['London', '2022-08-29T08:09:31'];