Make sql_insert_id a atomic function which executes the insert query and when that...

Make sql_insert_id a atomic function which executes the insert query and when that succeeds retrieves the id the database used for storing the inserted record. Some databases want this to be atomic (e.g. without a COMMIT in between.) Coding wise this is also much cleaner.