/** * Compile a select query into SQL. * * @param \Illuminate\Database\Query\Builder * @return string */ public function compileSelect(Builder $query) { $sql = parent::compileSelect($query); if ($query->unions) { $sql = '(' . $sql . ') ' . $this->compileUnions($query); } return $sql; }
/** * Compile a select query into SQL. * * @param \Illuminate\Database\Query\Builder * @return string */ public function compileSelect(Builder $query) { $sql = parent::compileSelect($query); if ($query->unions) { $sql = '(' . $sql . ') ' . $this->compileUnions($query); } if (isset($query->limit) || isset($query->offset)) { $limit = isset($query->limit) ? ' first ' . (int) $query->limit : ''; $offset = isset($query->offset) ? ' skip ' . (int) $query->offset : ''; $sql = str_replace("select", "select" . $limit . $offset, $sql); } return $sql; }
/** * Get the SQL representation of the query. * * @return string */ public function toSql() { return $this->grammar->compileSelect($this); }