[DB-6244] implemented returning generated id, following convention set by mysql