CedarDB for developers and operators.

$ curl https://get.cedardb.com | bash
$ ./cedar/cedardb --interactive

-- schema
create table movies (
  id integer primary key,
  title text, year int, genre text);
create table stars (
  id integer primary key,
  name text, birthdate date);
create table starsIn (
  movie_id int, star_id int);

-- query
select genre, avg(age(birthdate)) avg_age
from movies
  join starsIn on movies.id = movie_id
  join stars on star_id = stars.id
group by genre;