it executes in a transaction but we wouldn't generally recommend doing it this way