
Adds an item that is to be returned in the query result. This should only be used for literal SQL expressions as no quoting/escaping of any kind will be performed on the items.
Example with calculating distance:
/** * @var QueryBuilder $queryBuilder */ $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('my_table_name'); $queryBuilder->addSelectLiteral('( 3959 * acos(cos(radians(' . $this->lat . '))' . '* cos( radians( ' . $this->dbLatitude . ' ) )' . '* cos( radians( ' . $this->dbLongitude . ' )' . '- radians(' . $this->long . ') )' . '+ sin( radians(' . $this->lat . ') )' . '* sin( radians( ' . $this->dbLatitude . ' ) ) ) ) as ' . $asName);