Insert

# Wrap everything in a `SELECT` to also display the
# entire inserted structure.
SELECT (
    INSERT Text {
        title := 'Anonymous post',
        body := 'Showcasing "nested insert" pattern.',
        author := (
            INSERT User {
                name := 'Anonymous',
                email :=
                  # We use the UUID function to generate
                  # a unique placeholder email.
                  <str>uuid_generate_v1mc() ++
                  '@placeholder.edgedb.com'
            }
        )
    }
) {
    title,
    body,
    post_date,
    author: {
        id,
        name,
        email
    }
}

SELECT (
    INSERT Text {
        title := 'Another anonymous post',
        body := 'New post = new placeholder user.',
        author := (
            INSERT User {
                name := 'Anonymous',
                email := <str>uuid_generate_v1mc() ++
                  '@placeholder.edgedb.com'
            }
        )
    }
) {
    title,
    body,
    post_date,
    author: {
        id,
        name,
        email
    }
}