Insert

Subtopics

EdgeQL Tutorial

Insert

You may have noticed that when you run an insert command, some data is returned as the result. Every insert is also a query that returns the object that was just inserted along with its id. It is possible to get more than just the id by using select and applying a shape to the returned insert as a whole:

Input

Run

# Wrap the entire insert with parentheses to treat it as
# an expression which can then be selected.
select (
  insert Account {
    username := 'evans_fan',
    watchlist := (
      # Using a sub-query to fetch the existing movies.
      select Movie filter .actors.name = 'Chris Evans'
    )
  }
) {
  username,
  watchlist: {
    title
  }
};

# Wrap the entire insert with parentheses to treat it as
# an expression which can then be selected.
select (
  insert Account {
    username := 'evans_fan',
    watchlist := (
      # Using a sub-query to fetch the existing movies.
      select Movie filter .actors.name = 'Chris Evans'
    )
  }
) {
  username,
  watchlist: {
    title
  }
};

Output Objects

Press the 'Run' button to evaluate the input

Prev Next

We use ChatGPT with additional context from our documentation to answer your questions. Not all answers will be accurate. Please join our Discord if you need more help.