dicytea

    type User = {
      username: string;
      posts: Post[];
    }

    type Post = {
      content: string;
    }

    CREATE TABLE users (
        username text PRIMARY KEY
    );

    CREATE TABLE posts (
        author text NOT NULL REFERENCES users (username),
        content text NOT NULL
    );