code: def get_query_with_new_limit(self, new_limit):
          
          """does not change the underlying query"""
          if not self._limit:
              return self.sql + ' LIMIT ' + str(new_limit)
          limit_pos = None
          tokens = self._parsed[0].tokens
          # Add all items to before_str until there is a limit
          for pos, item in enumerate(tokens):
              if item.ttype in Keyword and item.value.lower() == 'limit':
                  limit_pos = pos
                  break
          limit = tokens[limit_pos + 2]
          if limit.ttype == sqlparse.tokens.Literal.Number.Integer:
              tokens[limit_pos + 2].value = new_limit
          elif limit.is_group:
              tokens[limit_pos + 2].value = (
                  '{}, {}'.format(next(limit.get_identifiers()), new_limit)
              )
  
          str_res = ''
          for i in tokens:
              str_res += str(i.value)
          return str_res
docs: returns the query with the specified limit