transformer refactoring
oracle dialect with limit offset support added