SpartanDB

distinct.spql

from users where {distinct username} select { username }

schema.spql

table users (id) {
  id: Id
  name: String
  balance: Float
}

table todos (id) {
  id: BigId
  text: String
  status: enum TodoStatus {
    COMPLETE
    INCOMPLETE
  }
}

simple_query.spql

from users select {
  id
  username
  password
  salt
}

union.spql

union {
  users where { status = UserStatus.CONFIRMED },
  users where { status = UserStatus.UNKNOWN }
}

variables.spql

let completedTodos = todos where { status = TodoStatus.COMPLETE };

from completedTodos select {
  id
  text
}