Typical examples are adding a column or an index. The risk is not the SQL itself but the locks it takes on a live table. Tools such as goose or Flyway only run the files in order; they do not make a dangerous statement safe.