code: public function buildOrderByAndLimit($sql, $orderBy, $limit, $offset)
      {
          if (!$this->hasOffset($offset) && !$this->hasLimit($limit)) {
              $orderBy = $this->buildOrderBy($orderBy);
              return $orderBy === '' ? $sql : $sql . $this->separator . $orderBy;
          }
  
          if (version_compare($this->db->getSchema()->getServerVersion(), '11', '<')) {
              return $this->oldBuildOrderByAndLimit($sql, $orderBy, $limit, $offset);
          }
  
          return $this->newBuildOrderByAndLimit($sql, $orderBy, $limit, $offset);
      }
docs: {@inheritdoc}