support for LIMIT and OFFSET in data translation mode