mysql: type="post" SELECT select last_insert_id()
sqlserver: type="post" SELECT @@identity AS ID
oracle: type="pre" SELECT sequenceName.nextval AS ID FROM DUAL
DB2: type="pre" values nextval for sequenceName
oracle: select sys_guid() AS ID FROM DUAL