Functional database query language

query.txt

# create table users
schema users =
  {
    id: serial;
    name: string;
    age: int;
  }

# select * from users
users

# select id, name from users
users.{id, name}

# select * from users where id > 2
users where id > 2

# select name from users where id = 3
let selected = users where id = 3 in
selected.{name}

### relationships...

# When a user is created, so is a profile.
# `profile` becomes a field on `user`.
schema profiles : belongs_to(profile) user =
{
  avatar_url: string?;
}

# For example, fetch Bob's profile picture:
let bob = one (users where name = "Bob") in
{pic: bob.profile.avatar_url or "none"}

# Has-many
# In this case, a "has_many_profiles_id" is added to the profiles schema,
# and deleting a has_many_profiles will wipe all related profiles.
schema has_many_profiles =
  {
    profiles: many profiles
  }
  
# Many-to-many
schema profile_types =
  {
    name: string;
  }

# Creates an associative table between the two, which depends on both.
schema profile_type_to_profile = pivot(profiles, profile_types)