The easiest DSL for database schemas

# sample AML

users
  id uuid pk
  name varchar
  email varchar unique
  role user_role(admin, guest)=guest

posts
  id uuid pk
  title varchar
  content text | in markdown
  created_at timestamp=`now()`
  created_by uuid -> users(id) # inline relation

CREATE TABLE users (
    id UUID PRIMARY KEY,
    name VARCHAR,
    email VARCHAR UNIQUE,
    role VARCHAR DEFAULT 'guest' CHECK (role IN ('admin', 'guest'))
);

CREATE TABLE posts (
   id UUID PRIMARY KEY,
   title VARCHAR,
   content TEXT,
   created_at TIMESTAMP DEFAULT now(),
   created_by UUID REFERENCES users(id) -- inline relation
);
COMMENT ON COLUMN posts.content IS 'in markdown';

{
  entities: [
    {
      name: 'users',
      attrs: [
        {name: 'id', type: 'uuid'},
        {name: 'name', type: 'varchar'},
        {name: 'email', type: 'varchar'},
        {name: 'role', type: 'user_role', default: 'guest'}
      ],
      pk: {attrs: [['id']]},
      indexes: [{attrs: [['email']], unique: true}]
    },
    {
      name: 'posts',
      attrs: [
        {name: 'id', type: 'uuid'},
        {name: 'title', type: 'varchar'},
        {name: 'content', type: 'text', doc: 'in markdown'},
        {name: 'created_at', type: 'timestamp', default: '`now()`'},
        {name: 'created_by', type: 'uuid'}
      ],
      pk: {attrs: [['id']]},
    }
  ],
  relations: [{
    src: {entity: 'posts'},
    ref: {entity: 'users'},
    attrs: [{src: ['created_by'], ref: ['id']}]
  }]
}