/**
* 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);
}
