nextcloud / server

lib/public/DB/Types.php

Indentation +162 added lines, -162 removed lines

@@ -16,166 +16,166 @@
  * @since 21.0.0
  */
 final class Types {
-	/**
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const BIGINT = 'bigint';
-
-	/**
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const BINARY = 'binary';
-
-	/**
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const BLOB = 'blob';
-
-	/**
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const BOOLEAN = 'boolean';
-
-	/**
-	 * A datetime instance with only the date set.
-	 * This will be (de)serialized into a \DateTime instance,
-	 * it is recommended to instead use the `DATE_IMMUTABLE` instead.
-	 *
-	 * Warning: When deserialized the timezone will be set to UTC.
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const DATE = 'date';
-
-	/**
-	 * An immutable datetime instance with only the date set.
-	 * This will be (de)serialized into a \DateTimeImmutable instance,
-	 * It is recommended to use this over the `DATE` type because
-	 * out `Entity` class works detecting changes through the setter,
-	 * changes on mutable objects can not be detected.
-	 *
-	 * Warning: When deserialized the timezone will be set to UTC.
-	 * @var string
-	 * @since 31.0.0
-	 */
-	public const DATE_IMMUTABLE = 'date_immutable';
-
-	/**
-	 * A datetime instance with date and time support.
-	 * This will be (de)serialized into a \DateTime instance,
-	 * it is recommended to instead use the `DATETIME_IMMUTABLE` instead.
-	 *
-	 * Warning: When deserialized the timezone will be set to UTC.
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const DATETIME = 'datetime';
-
-	/**
-	 * An immutable datetime instance with date and time set.
-	 * This will be (de)serialized into a \DateTimeImmutable instance,
-	 * It is recommended to use this over the `DATETIME` type because
-	 * out `Entity` class works detecting changes through the setter,
-	 * changes on mutable objects can not be detected.
-	 *
-	 * Warning: When deserialized the timezone will be set to UTC.
-	 * @var string
-	 * @since 31.0.0
-	 */
-	public const DATETIME_IMMUTABLE = 'datetime_immutable';
-
-
-	/**
-	 * A datetime instance with timezone support
-	 * This will be (de)serialized into a \DateTime instance,
-	 * it is recommended to instead use the `DATETIME_TZ_IMMUTABLE` instead.
-	 *
-	 * @var string
-	 * @since 31.0.0
-	 */
-	public const DATETIME_TZ = 'datetimetz';
-
-	/**
-	 * An immutable timezone aware datetime instance with date and time set.
-	 * This will be (de)serialized into a \DateTimeImmutable instance,
-	 * It is recommended to use this over the `DATETIME_TZ` type because
-	 * out `Entity` class works detecting changes through the setter,
-	 * changes on mutable objects can not be detected.
-	 *
-	 * @var string
-	 * @since 31.0.0
-	 */
-	public const DATETIME_TZ_IMMUTABLE = 'datetimetz_immutable';
-
-	/**
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const DECIMAL = 'decimal';
-
-	/**
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const FLOAT = 'float';
-
-	/**
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const INTEGER = 'integer';
-
-	/**
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const SMALLINT = 'smallint';
-
-	/**
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const STRING = 'string';
-
-	/**
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const TEXT = 'text';
-
-	/**
-	 * A datetime instance with only the time set.
-	 * This will be (de)serialized into a \DateTime instance,
-	 * it is recommended to instead use the `TIME_IMMUTABLE` instead.
-	 *
-	 * Warning: When deserialized the timezone will be set to UTC.
-	 * @var string
-	 * @since 21.0.0
-	 */
-	public const TIME = 'time';
-
-	/**
-	 * A datetime instance with only the time set.
-	 * This will be (de)serialized into a \DateTime instance.
-	 *
-	 * It is recommended to use this over the `DATETIME_TZ` type because
-	 * out `Entity` class works detecting changes through the setter,
-	 * changes on mutable objects can not be detected.
-	 *
-	 * @var string
-	 * @since 31.0.0
-	 */
-	public const TIME_IMMUTABLE = 'time_immutable';
-
-	/**
-	 * @var string
-	 * @since 24.0.0
-	 * @deprecated 33.0.0 JSON fields can not properly be used in WHERE statements of Oracle and MySQL.
-	 *                    It is recommended to use a simple STRING field and handle JSON within PHP
-	 */
-	public const JSON = 'json';
+    /**
+     * @var string
+     * @since 21.0.0
+     */
+    public const BIGINT = 'bigint';
+
+    /**
+     * @var string
+     * @since 21.0.0
+     */
+    public const BINARY = 'binary';
+
+    /**
+     * @var string
+     * @since 21.0.0
+     */
+    public const BLOB = 'blob';
+
+    /**
+     * @var string
+     * @since 21.0.0
+     */
+    public const BOOLEAN = 'boolean';
+
+    /**
+     * A datetime instance with only the date set.
+     * This will be (de)serialized into a \DateTime instance,
+     * it is recommended to instead use the `DATE_IMMUTABLE` instead.
+     *
+     * Warning: When deserialized the timezone will be set to UTC.
+     * @var string
+     * @since 21.0.0
+     */
+    public const DATE = 'date';
+
+    /**
+     * An immutable datetime instance with only the date set.
+     * This will be (de)serialized into a \DateTimeImmutable instance,
+     * It is recommended to use this over the `DATE` type because
+     * out `Entity` class works detecting changes through the setter,
+     * changes on mutable objects can not be detected.
+     *
+     * Warning: When deserialized the timezone will be set to UTC.
+     * @var string
+     * @since 31.0.0
+     */
+    public const DATE_IMMUTABLE = 'date_immutable';
+
+    /**
+     * A datetime instance with date and time support.
+     * This will be (de)serialized into a \DateTime instance,
+     * it is recommended to instead use the `DATETIME_IMMUTABLE` instead.
+     *
+     * Warning: When deserialized the timezone will be set to UTC.
+     * @var string
+     * @since 21.0.0
+     */
+    public const DATETIME = 'datetime';
+
+    /**
+     * An immutable datetime instance with date and time set.
+     * This will be (de)serialized into a \DateTimeImmutable instance,
+     * It is recommended to use this over the `DATETIME` type because
+     * out `Entity` class works detecting changes through the setter,
+     * changes on mutable objects can not be detected.
+     *
+     * Warning: When deserialized the timezone will be set to UTC.
+     * @var string
+     * @since 31.0.0
+     */
+    public const DATETIME_IMMUTABLE = 'datetime_immutable';
+
+
+    /**
+     * A datetime instance with timezone support
+     * This will be (de)serialized into a \DateTime instance,
+     * it is recommended to instead use the `DATETIME_TZ_IMMUTABLE` instead.
+     *
+     * @var string
+     * @since 31.0.0
+     */
+    public const DATETIME_TZ = 'datetimetz';
+
+    /**
+     * An immutable timezone aware datetime instance with date and time set.
+     * This will be (de)serialized into a \DateTimeImmutable instance,
+     * It is recommended to use this over the `DATETIME_TZ` type because
+     * out `Entity` class works detecting changes through the setter,
+     * changes on mutable objects can not be detected.
+     *
+     * @var string
+     * @since 31.0.0
+     */
+    public const DATETIME_TZ_IMMUTABLE = 'datetimetz_immutable';
+
+    /**
+     * @var string
+     * @since 21.0.0
+     */
+    public const DECIMAL = 'decimal';
+
+    /**
+     * @var string
+     * @since 21.0.0
+     */
+    public const FLOAT = 'float';
+
+    /**
+     * @var string
+     * @since 21.0.0
+     */
+    public const INTEGER = 'integer';
+
+    /**
+     * @var string
+     * @since 21.0.0
+     */
+    public const SMALLINT = 'smallint';
+
+    /**
+     * @var string
+     * @since 21.0.0
+     */
+    public const STRING = 'string';
+
+    /**
+     * @var string
+     * @since 21.0.0
+     */
+    public const TEXT = 'text';
+
+    /**
+     * A datetime instance with only the time set.
+     * This will be (de)serialized into a \DateTime instance,
+     * it is recommended to instead use the `TIME_IMMUTABLE` instead.
+     *
+     * Warning: When deserialized the timezone will be set to UTC.
+     * @var string
+     * @since 21.0.0
+     */
+    public const TIME = 'time';
+
+    /**
+     * A datetime instance with only the time set.
+     * This will be (de)serialized into a \DateTime instance.
+     *
+     * It is recommended to use this over the `DATETIME_TZ` type because
+     * out `Entity` class works detecting changes through the setter,
+     * changes on mutable objects can not be detected.
+     *
+     * @var string
+     * @since 31.0.0
+     */
+    public const TIME_IMMUTABLE = 'time_immutable';
+
+    /**
+     * @var string
+     * @since 24.0.0
+     * @deprecated 33.0.0 JSON fields can not properly be used in WHERE statements of Oracle and MySQL.
+     *                    It is recommended to use a simple STRING field and handle JSON within PHP
+     */
+    public const JSON = 'json';
 }

lib/public/DB/QueryBuilder/IQueryBuilder.php

Indentation +1070 added lines, -1070 removed lines

@@ -22,1074 +22,1074 @@
  * @psalm-taint-specialize
  */
 interface IQueryBuilder {
-	/**
-	 * @since 9.0.0
-	 */
-	public const PARAM_NULL = ParameterType::NULL;
-	/**
-	 * @since 9.0.0
-	 */
-	public const PARAM_BOOL = Types::BOOLEAN;
-	/**
-	 * @since 9.0.0
-	 */
-	public const PARAM_INT = ParameterType::INTEGER;
-	/**
-	 * @since 9.0.0
-	 */
-	public const PARAM_STR = ParameterType::STRING;
-	/**
-	 * @since 9.0.0
-	 */
-	public const PARAM_LOB = ParameterType::LARGE_OBJECT;
-
-	/**
-	 * @since 9.0.0
-	 * @deprecated 31.0.0 - use PARAM_DATETIME_MUTABLE instead
-	 */
-	public const PARAM_DATE = Types::DATETIME_MUTABLE;
-
-	/**
-	 * For passing a \DateTime instance when only interested in the time part (without timezone support)
-	 * @since 31.0.0
-	 */
-	public const PARAM_TIME_MUTABLE = Types::TIME_MUTABLE;
-
-	/**
-	 * For passing a \DateTime instance when only interested in the date part (without timezone support)
-	 * @since 31.0.0
-	 */
-	public const PARAM_DATE_MUTABLE = Types::DATE_MUTABLE;
-
-	/**
-	 * For passing a \DateTime instance (without timezone support)
-	 * @since 31.0.0
-	 */
-	public const PARAM_DATETIME_MUTABLE = Types::DATETIME_MUTABLE;
-
-	/**
-	 * For passing a \DateTime instance with timezone support
-	 * @since 31.0.0
-	 */
-	public const PARAM_DATETIME_TZ_MUTABLE = Types::DATETIMETZ_MUTABLE;
-
-	/**
-	 * For passing a \DateTimeImmutable instance when only interested in the time part (without timezone support)
-	 * @since 31.0.0
-	 */
-	public const PARAM_TIME_IMMUTABLE = Types::TIME_MUTABLE;
-
-	/**
-	 * For passing a \DateTime instance when only interested in the date part (without timezone support)
-	 * @since 9.0.0
-	 */
-	public const PARAM_DATE_IMMUTABLE = Types::DATE_IMMUTABLE;
-
-	/**
-	 * For passing a \DateTime instance (without timezone support)
-	 * @since 31.0.0
-	 */
-	public const PARAM_DATETIME_IMMUTABLE = Types::DATETIME_IMMUTABLE;
-
-	/**
-	 * For passing a \DateTime instance with timezone support
-	 * @since 31.0.0
-	 */
-	public const PARAM_DATETIME_TZ_IMMUTABLE = Types::DATETIMETZ_IMMUTABLE;
-
-	/**
-	 * @since 24.0.0
-	 * @deprecated 33.0.0 JSON fields can not properly be used in WHERE statements of Oracle and MySQL.
-	 *                    It is recommended to use a simple STRING field and handle JSON within PHP
-	 */
-	public const PARAM_JSON = 'json';
-
-	/**
-	 * @since 9.0.0
-	 */
-	public const PARAM_INT_ARRAY = ArrayParameterType::INTEGER;
-	/**
-	 * @since 9.0.0
-	 */
-	public const PARAM_STR_ARRAY = ArrayParameterType::STRING;
-
-	/**
-	 * @since 24.0.0 Indicates how many rows can be deleted at once with MySQL
-	 * database server.
-	 */
-	public const MAX_ROW_DELETION = 100000;
-
-	/**
-	 * Enable/disable automatic prefixing of table names with the oc_ prefix
-	 *
-	 * @param bool $enabled If set to true table names will be prefixed with the
-	 *                      owncloud database prefix automatically.
-	 * @since 8.2.0
-	 */
-	public function automaticTablePrefix($enabled);
-
-	/**
-	 * Gets an ExpressionBuilder used for object-oriented construction of query expressions.
-	 * This producer method is intended for convenient inline usage. Example:
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u')
-	 *         ->from('users', 'u')
-	 *         ->where($qb->expr()->eq('u.id', 1));
-	 * </code>
-	 *
-	 * For more complex expression construction, consider storing the expression
-	 * builder object in a local variable.
-	 *
-	 * @return \OCP\DB\QueryBuilder\IExpressionBuilder
-	 * @since 8.2.0
-	 */
-	public function expr();
-
-	/**
-	 * Gets an FunctionBuilder used for object-oriented construction of query functions.
-	 * This producer method is intended for convenient inline usage. Example:
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u')
-	 *         ->from('users', 'u')
-	 *         ->where($qb->fun()->md5('u.id'));
-	 * </code>
-	 *
-	 * For more complex function construction, consider storing the function
-	 * builder object in a local variable.
-	 *
-	 * @return \OCP\DB\QueryBuilder\IFunctionBuilder
-	 * @since 12.0.0
-	 */
-	public function func();
-
-	/**
-	 * Gets the type of the currently built query.
-	 *
-	 * @return integer
-	 * @since 8.2.0
-	 */
-	public function getType();
-
-	/**
-	 * Gets the associated DBAL Connection for this query builder.
-	 *
-	 * @return \OCP\IDBConnection
-	 * @since 8.2.0
-	 */
-	public function getConnection();
-
-	/**
-	 * Gets the state of this query builder instance.
-	 *
-	 * @return integer Either QueryBuilder::STATE_DIRTY or QueryBuilder::STATE_CLEAN.
-	 * @since 8.2.0
-	 * @deprecated 30.0.0 This function is going to be removed with the next Doctrine/DBAL update
-	 *    and we can not fix this in our wrapper.
-	 */
-	public function getState();
-
-	/**
-	 * Execute for select statements
-	 *
-	 * @param ?IDBConnection $connection (optional) the connection to run the query against. since 30.0
-	 * @return IResult
-	 * @since 22.0.0
-	 *
-	 * @throws Exception
-	 * @throws \RuntimeException in case of usage with non select query
-	 */
-	public function executeQuery(?IDBConnection $connection = null): IResult;
-
-	/**
-	 * Execute insert, update and delete statements
-	 *
-	 * @param ?IDBConnection $connection (optional) the connection to run the query against. since 30.0
-	 * @return int the number of affected rows
-	 * @since 22.0.0
-	 *
-	 * @throws Exception
-	 * @throws \RuntimeException in case of usage with select query
-	 */
-	public function executeStatement(?IDBConnection $connection = null): int;
-
-	/**
-	 * Gets the complete SQL string formed by the current specifications of this QueryBuilder.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u')
-	 *         ->from('User', 'u')
-	 *     echo $qb->getSQL(); // SELECT u FROM User u
-	 * </code>
-	 *
-	 * @return string The SQL query string.
-	 * @since 8.2.0
-	 */
-	public function getSQL();
-
-	/**
-	 * Sets a query parameter for the query being constructed.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u')
-	 *         ->from('users', 'u')
-	 *         ->where('u.id = :user_id')
-	 *         ->setParameter(':user_id', 1);
-	 * </code>
-	 *
-	 * @param string|integer $key The parameter position or name.
-	 * @param mixed $value The parameter value.
-	 * @param string|null|int $type One of the IQueryBuilder::PARAM_* constants.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 */
-	public function setParameter($key, $value, $type = null);
-
-	/**
-	 * Sets a collection of query parameters for the query being constructed.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u')
-	 *         ->from('users', 'u')
-	 *         ->where('u.id = :user_id1 OR u.id = :user_id2')
-	 *         ->setParameters(array(
-	 *             ':user_id1' => 1,
-	 *             ':user_id2' => 2
-	 *         ));
-	 * </code>
-	 *
-	 * @param array $params The query parameters to set.
-	 * @param array $types The query parameters types to set.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 */
-	public function setParameters(array $params, array $types = []);
-
-	/**
-	 * Gets all defined query parameters for the query being constructed indexed by parameter index or name.
-	 *
-	 * @return array The currently defined query parameters indexed by parameter index or name.
-	 * @since 8.2.0
-	 */
-	public function getParameters();
-
-	/**
-	 * Gets a (previously set) query parameter of the query being constructed.
-	 *
-	 * @param mixed $key The key (index or name) of the bound parameter.
-	 *
-	 * @return mixed The value of the bound parameter.
-	 * @since 8.2.0
-	 */
-	public function getParameter($key);
-
-	/**
-	 * Gets all defined query parameter types for the query being constructed indexed by parameter index or name.
-	 *
-	 * @return array The currently defined query parameter types indexed by parameter index or name.
-	 * @since 8.2.0
-	 */
-	public function getParameterTypes();
-
-	/**
-	 * Gets a (previously set) query parameter type of the query being constructed.
-	 *
-	 * @param mixed $key The key (index or name) of the bound parameter type.
-	 *
-	 * @return mixed The value of the bound parameter type.
-	 * @since 8.2.0
-	 */
-	public function getParameterType($key);
-
-	/**
-	 * Sets the position of the first result to retrieve (the "offset").
-	 *
-	 * @param int $firstResult The first result to return.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 */
-	public function setFirstResult($firstResult);
-
-	/**
-	 * Gets the position of the first result the query object was set to retrieve (the "offset").
-	 * Returns 0 if {@link setFirstResult} was not applied to this QueryBuilder.
-	 *
-	 * @return int The position of the first result.
-	 * @since 8.2.0
-	 */
-	public function getFirstResult();
-
-	/**
-	 * Sets the maximum number of results to retrieve (the "limit").
-	 *
-	 * @param int|null $maxResults The maximum number of results to retrieve.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 */
-	public function setMaxResults($maxResults);
-
-	/**
-	 * Gets the maximum number of results the query object was set to retrieve (the "limit").
-	 * Returns NULL if {@link setMaxResults} was not applied to this query builder.
-	 *
-	 * @return int|null The maximum number of results.
-	 * @since 8.2.0
-	 */
-	public function getMaxResults();
-
-	/**
-	 * Specifies an item that is to be returned in the query result.
-	 * Replaces any previously specified selections, if any.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.id', 'p.id')
-	 *         ->from('users', 'u')
-	 *         ->leftJoin('u', 'phonenumbers', 'p', 'u.id = p.user_id');
-	 * </code>
-	 *
-	 * @param mixed ...$selects The selection expressions.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $selects
-	 */
-	public function select(...$selects);
-
-	/**
-	 * Specifies an item that is to be returned with a different name in the query result.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->selectAlias('u.id', 'user_id')
-	 *         ->from('users', 'u')
-	 *         ->leftJoin('u', 'phonenumbers', 'p', 'u.id = p.user_id');
-	 * </code>
-	 *
-	 * @param mixed $select The selection expressions.
-	 * @param string $alias The column alias used in the constructed query.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.1
-	 *
-	 * @psalm-taint-sink sql $select
-	 * @psalm-taint-sink sql $alias
-	 */
-	public function selectAlias($select, $alias);
-
-	/**
-	 * Specifies an item that is to be returned uniquely in the query result.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->selectDistinct('type')
-	 *         ->from('users');
-	 * </code>
-	 *
-	 * @param mixed $select The selection expressions.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 9.0.0
-	 *
-	 * @psalm-taint-sink sql $select
-	 */
-	public function selectDistinct($select);
-
-	/**
-	 * Adds an item that is to be returned in the query result.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.id')
-	 *         ->addSelect('p.id')
-	 *         ->from('users', 'u')
-	 *         ->leftJoin('u', 'phonenumbers', 'u.id = p.user_id');
-	 * </code>
-	 *
-	 * @param mixed ...$select The selection expression.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $select
-	 */
-	public function addSelect(...$select);
-
-	/**
-	 * Turns the query being built into a bulk delete query that ranges over
-	 * a certain table.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->delete('users')
-	 *         ->where('id = :user_id');
-	 *         ->setParameter(':user_id', 1);
-	 * </code>
-	 *
-	 * @param string $delete The table whose rows are subject to the deletion.
-	 * @param string $alias The table alias used in the constructed query.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 * @since 30.0.0 Alias is deprecated and will no longer be used with the next Doctrine/DBAL update
-	 *
-	 * @psalm-taint-sink sql $delete
-	 */
-	public function delete($delete = null, $alias = null);
-
-	/**
-	 * Turns the query being built into a bulk update query that ranges over
-	 * a certain table
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->update('users')
-	 *         ->set('email', ':email')
-	 *         ->where('id = :user_id');
-	 *         ->setParameter(':user_id', 1);
-	 * </code>
-	 *
-	 * @param string $update The table whose rows are subject to the update.
-	 * @param string $alias The table alias used in the constructed query.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 * @since 30.0.0 Alias is deprecated and will no longer be used with the next Doctrine/DBAL update
-	 *
-	 * @psalm-taint-sink sql $update
-	 */
-	public function update($update = null, $alias = null);
-
-	/**
-	 * Turns the query being built into an insert query that inserts into
-	 * a certain table
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->insert('users')
-	 *         ->values(
-	 *             array(
-	 *                 'name' => '?',
-	 *                 'password' => '?'
-	 *             )
-	 *         );
-	 * </code>
-	 *
-	 * @param string $insert The table into which the rows should be inserted.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $insert
-	 */
-	public function insert($insert = null);
-
-	/**
-	 * Creates and adds a query root corresponding to the table identified by the
-	 * given alias, forming a cartesian product with any existing query roots.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.id')
-	 *         ->from('users', 'u')
-	 * </code>
-	 *
-	 * @param string|IQueryFunction $from The table.
-	 * @param string|null $alias The alias of the table.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $from
-	 */
-	public function from($from, $alias = null);
-
-	/**
-	 * Creates and adds a join to the query.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.name')
-	 *         ->from('users', 'u')
-	 *         ->join('u', 'phonenumbers', 'p', 'p.is_primary = 1');
-	 * </code>
-	 *
-	 * @param string $fromAlias The alias that points to a from clause.
-	 * @param string|IQueryFunction $join The table name to join.
-	 * @param string $alias The alias of the join table.
-	 * @param string|ICompositeExpression|null $condition The condition for the join.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $fromAlias
-	 * @psalm-taint-sink sql $join
-	 * @psalm-taint-sink sql $alias
-	 * @psalm-taint-sink sql $condition
-	 */
-	public function join($fromAlias, $join, $alias, $condition = null);
-
-	/**
-	 * Creates and adds a join to the query.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.name')
-	 *         ->from('users', 'u')
-	 *         ->innerJoin('u', 'phonenumbers', 'p', 'p.is_primary = 1');
-	 * </code>
-	 *
-	 * @param string $fromAlias The alias that points to a from clause.
-	 * @param string|IQueryFunction $join The table name to join.
-	 * @param string $alias The alias of the join table.
-	 * @param string|ICompositeExpression|null $condition The condition for the join.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $fromAlias
-	 * @psalm-taint-sink sql $join
-	 * @psalm-taint-sink sql $alias
-	 * @psalm-taint-sink sql $condition
-	 */
-	public function innerJoin($fromAlias, $join, $alias, $condition = null);
-
-	/**
-	 * Creates and adds a left join to the query.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.name')
-	 *         ->from('users', 'u')
-	 *         ->leftJoin('u', 'phonenumbers', 'p', 'p.is_primary = 1');
-	 * </code>
-	 *
-	 * @param string $fromAlias The alias that points to a from clause.
-	 * @param string|IQueryFunction $join The table name to join.
-	 * @param string $alias The alias of the join table.
-	 * @param string|ICompositeExpression|null $condition The condition for the join.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 * @since 30.0.0 Allow passing IQueryFunction as parameter for `$join` to allow join with a sub-query.
-	 *
-	 * @psalm-taint-sink sql $fromAlias
-	 * @psalm-taint-sink sql $join
-	 * @psalm-taint-sink sql $alias
-	 * @psalm-taint-sink sql $condition
-	 */
-	public function leftJoin($fromAlias, $join, $alias, $condition = null);
-
-	/**
-	 * Creates and adds a right join to the query.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.name')
-	 *         ->from('users', 'u')
-	 *         ->rightJoin('u', 'phonenumbers', 'p', 'p.is_primary = 1');
-	 * </code>
-	 *
-	 * @param string $fromAlias The alias that points to a from clause.
-	 * @param string|IQueryFunction $join The table name to join.
-	 * @param string $alias The alias of the join table.
-	 * @param string|ICompositeExpression|null $condition The condition for the join.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $fromAlias
-	 * @psalm-taint-sink sql $join
-	 * @psalm-taint-sink sql $alias
-	 * @psalm-taint-sink sql $condition
-	 */
-	public function rightJoin($fromAlias, $join, $alias, $condition = null);
-
-	/**
-	 * Sets a new value for a column in a bulk update query.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->update('users', 'u')
-	 *         ->set('u.password', md5('password'))
-	 *         ->where('u.id = ?');
-	 * </code>
-	 *
-	 * @param string $key The column to set.
-	 * @param ILiteral|IParameter|IQueryFunction|string $value The value, expression, placeholder, etc.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $key
-	 * @psalm-taint-sink sql $value
-	 */
-	public function set($key, $value);
-
-	/**
-	 * Specifies one or more restrictions to the query result.
-	 * Replaces any previously specified restrictions, if any.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.name')
-	 *         ->from('users', 'u')
-	 *         ->where('u.id = ?');
-	 *
-	 *     // You can optionally programmatically build and/or expressions
-	 *     $qb = $conn->getQueryBuilder();
-	 *
-	 *     $or = $qb->expr()->orx(
-	 *         $qb->expr()->eq('u.id', 1),
-	 *         $qb->expr()->eq('u.id', 2),
-	 *     );
-	 *
-	 *     $qb->update('users', 'u')
-	 *         ->set('u.password', md5('password'))
-	 *         ->where($or);
-	 * </code>
-	 *
-	 * @param mixed $predicates The restriction predicates.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $predicates
-	 */
-	public function where(...$predicates);
-
-	/**
-	 * Adds one or more restrictions to the query results, forming a logical
-	 * conjunction with any previously specified restrictions.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u')
-	 *         ->from('users', 'u')
-	 *         ->where('u.username LIKE ?')
-	 *         ->andWhere('u.is_active = 1');
-	 * </code>
-	 *
-	 * @param mixed ...$where The query restrictions.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 *
-	 * @see where()
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $where
-	 */
-	public function andWhere(...$where);
-
-	/**
-	 * Adds one or more restrictions to the query results, forming a logical
-	 * disjunction with any previously specified restrictions.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.name')
-	 *         ->from('users', 'u')
-	 *         ->where('u.id = 1')
-	 *         ->orWhere('u.id = 2');
-	 * </code>
-	 *
-	 * @param mixed ...$where The WHERE statement.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 *
-	 * @see where()
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $where
-	 */
-	public function orWhere(...$where);
-
-	/**
-	 * Specifies a grouping over the results of the query.
-	 * Replaces any previously specified groupings, if any.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.name')
-	 *         ->from('users', 'u')
-	 *         ->groupBy('u.id');
-	 * </code>
-	 *
-	 * @param mixed ...$groupBys The grouping expression.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $groupBys
-	 */
-	public function groupBy(...$groupBys);
-
-	/**
-	 * Adds a grouping expression to the query.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->select('u.name')
-	 *         ->from('users', 'u')
-	 *         ->groupBy('u.lastLogin');
-	 *         ->addGroupBy('u.createdAt')
-	 * </code>
-	 *
-	 * @param mixed ...$groupBy The grouping expression.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $groupby
-	 */
-	public function addGroupBy(...$groupBy);
-
-	/**
-	 * Sets a value for a column in an insert query.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->insert('users')
-	 *         ->values(
-	 *             array(
-	 *                 'name' => '?'
-	 *             )
-	 *         )
-	 *         ->setValue('password', '?');
-	 * </code>
-	 *
-	 * @param string $column The column into which the value should be inserted.
-	 * @param IParameter|string $value The value that should be inserted into the column.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $column
-	 * @psalm-taint-sink sql $value
-	 */
-	public function setValue($column, $value);
-
-	/**
-	 * Specifies values for an insert query indexed by column names.
-	 * Replaces any previous values, if any.
-	 *
-	 * <code>
-	 *     $qb = $conn->getQueryBuilder()
-	 *         ->insert('users')
-	 *         ->values(
-	 *             array(
-	 *                 'name' => '?',
-	 *                 'password' => '?'
-	 *             )
-	 *         );
-	 * </code>
-	 *
-	 * @param array $values The values to specify for the insert query indexed by column names.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $values
-	 */
-	public function values(array $values);
-
-	/**
-	 * Specifies a restriction over the groups of the query.
-	 * Replaces any previous having restrictions, if any.
-	 *
-	 * @param mixed ...$having The restriction over the groups.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $having
-	 */
-	public function having(...$having);
-
-	/**
-	 * Adds a restriction over the groups of the query, forming a logical
-	 * conjunction with any existing having restrictions.
-	 *
-	 * @param mixed ...$having The restriction to append.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $andHaving
-	 */
-	public function andHaving(...$having);
-
-	/**
-	 * Adds a restriction over the groups of the query, forming a logical
-	 * disjunction with any existing having restrictions.
-	 *
-	 * @param mixed ...$having The restriction to add.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $having
-	 */
-	public function orHaving(...$having);
-
-	/**
-	 * Specifies an ordering for the query results.
-	 * Replaces any previously specified orderings, if any.
-	 *
-	 * @param string|IQueryFunction|ILiteral|IParameter $sort The ordering expression.
-	 * @param string $order The ordering direction.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $sort
-	 * @psalm-taint-sink sql $order
-	 */
-	public function orderBy($sort, $order = null);
-
-	/**
-	 * Adds an ordering to the query results.
-	 *
-	 * @param string|ILiteral|IParameter|IQueryFunction $sort The ordering expression.
-	 * @param string $order The ordering direction.
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $sort
-	 * @psalm-taint-sink sql $order
-	 */
-	public function addOrderBy($sort, $order = null);
-
-	/**
-	 * Gets a query part by its name.
-	 *
-	 * @param string $queryPartName
-	 *
-	 * @return mixed
-	 * @since 8.2.0
-	 * @deprecated 30.0.0 This function is going to be removed with the next Doctrine/DBAL update
-	 *  and we can not fix this in our wrapper. Please track the details you need, outside the object.
-	 */
-	public function getQueryPart($queryPartName);
-
-	/**
-	 * Gets all query parts.
-	 *
-	 * @return array
-	 * @since 8.2.0
-	 * @deprecated 30.0.0 This function is going to be removed with the next Doctrine/DBAL update
-	 *  and we can not fix this in our wrapper. Please track the details you need, outside the object.
-	 */
-	public function getQueryParts();
-
-	/**
-	 * Resets SQL parts.
-	 *
-	 * @param array|null $queryPartNames
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 * @deprecated 30.0.0 This function is going to be removed with the next Doctrine/DBAL update
-	 * and we can not fix this in our wrapper. Please create a new IQueryBuilder instead.
-	 */
-	public function resetQueryParts($queryPartNames = null);
-
-	/**
-	 * Resets a single SQL part.
-	 *
-	 * @param string $queryPartName
-	 *
-	 * @return $this This QueryBuilder instance.
-	 * @since 8.2.0
-	 * @deprecated 30.0.0 This function is going to be removed with the next Doctrine/DBAL update
-	 *  and we can not fix this in our wrapper. Please create a new IQueryBuilder instead.
-	 */
-	public function resetQueryPart($queryPartName);
-
-	/**
-	 * Creates a new named parameter and bind the value $value to it.
-	 *
-	 * This method provides a shortcut for PDOStatement::bindValue
-	 * when using prepared statements.
-	 *
-	 * The parameter $value specifies the value that you want to bind. If
-	 * $placeholder is not provided bindValue() will automatically create a
-	 * placeholder for you. An automatic placeholder will be of the name
-	 * ':dcValue1', ':dcValue2' etc.
-	 *
-	 * For more information see {@link https://www.php.net/pdostatement-bindparam}
-	 *
-	 * Example:
-	 * <code>
-	 * $value = 2;
-	 * $q->eq( 'id', $q->bindValue( $value ) );
-	 * $stmt = $q->executeQuery(); // executed with 'id = 2'
-	 * </code>
-	 *
-	 * @license New BSD License
-	 * @link http://www.zetacomponents.org
-	 *
-	 * @param mixed $value
-	 * @param self::PARAM_* $type
-	 * @param string $placeHolder The name to bind with. The string must start with a colon ':'.
-	 *
-	 * @return IParameter
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-escape sql
-	 */
-	public function createNamedParameter($value, $type = self::PARAM_STR, $placeHolder = null);
-
-	/**
-	 * Creates a new positional parameter and bind the given value to it.
-	 *
-	 * Attention: If you are using positional parameters with the query builder you have
-	 * to be very careful to bind all parameters in the order they appear in the SQL
-	 * statement , otherwise they get bound in the wrong order which can lead to serious
-	 * bugs in your code.
-	 *
-	 * Example:
-	 * <code>
-	 *  $qb = $conn->getQueryBuilder();
-	 *  $qb->select('u.*')
-	 *     ->from('users', 'u')
-	 *     ->where('u.username = ' . $qb->createPositionalParameter('Foo', IQueryBuilder::PARAM_STR))
-	 *     ->orWhere('u.username = ' . $qb->createPositionalParameter('Bar', IQueryBuilder::PARAM_STR))
-	 * </code>
-	 *
-	 * @param mixed $value
-	 * @param self::PARAM_* $type
-	 *
-	 * @return IParameter
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-escape sql
-	 */
-	public function createPositionalParameter($value, $type = self::PARAM_STR);
-
-	/**
-	 * Creates a new parameter
-	 *
-	 * Example:
-	 * <code>
-	 *  $qb = $conn->getQueryBuilder();
-	 *  $qb->select('u.*')
-	 *     ->from('users', 'u')
-	 *     ->where('u.username = ' . $qb->createParameter('name'))
-	 *     ->setParameter('name', 'Bar', IQueryBuilder::PARAM_STR))
-	 * </code>
-	 *
-	 * @param string $name
-	 *
-	 * @return IParameter
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-escape sql
-	 */
-	public function createParameter($name);
-
-	/**
-	 * Creates a new function
-	 *
-	 * Attention: Column names inside the call have to be quoted before hand
-	 *
-	 * Example:
-	 * <code>
-	 *  $qb = $conn->getQueryBuilder();
-	 *  $qb->select($qb->createFunction('COUNT(*)'))
-	 *     ->from('users', 'u')
-	 *  echo $qb->getSQL(); // SELECT COUNT(*) FROM `users` u
-	 * </code>
-	 * <code>
-	 *  $qb = $conn->getQueryBuilder();
-	 *  $qb->select($qb->createFunction('COUNT(`column`)'))
-	 *     ->from('users', 'u')
-	 *  echo $qb->getSQL(); // SELECT COUNT(`column`) FROM `users` u
-	 * </code>
-	 *
-	 * @param string $call
-	 *
-	 * @return IQueryFunction
-	 * @since 8.2.0
-	 *
-	 * @psalm-taint-sink sql $call
-	 */
-	public function createFunction($call);
-
-	/**
-	 * Used to get the id of the last inserted element
-	 * @return int
-	 * @throws \BadMethodCallException When being called before an insert query has been run.
-	 * @since 9.0.0
-	 */
-	public function getLastInsertId(): int;
-
-	/**
-	 * Returns the table name quoted and with database prefix as needed by the implementation.
-	 * If a query function is passed the function is casted to string,
-	 * this allows passing functions as sub-queries for join expression.
-	 *
-	 * @param string|IQueryFunction $table
-	 * @return string
-	 * @since 9.0.0
-	 * @since 24.0.0 accepts IQueryFunction as parameter
-	 */
-	public function getTableName($table);
-
-	/**
-	 * Returns the table name with database prefix as needed by the implementation
-	 *
-	 * @param string $table
-	 * @return string
-	 * @since 30.0.0
-	 */
-	public function prefixTableName(string $table): string;
-
-	/**
-	 * Returns the column name quoted and with table alias prefix as needed by the implementation
-	 *
-	 * @param string $column
-	 * @param string $tableAlias
-	 * @return string
-	 * @since 9.0.0
-	 */
-	public function getColumnName($column, $tableAlias = '');
-
-	/**
-	 * Provide a hint for the shard key for queries where this can't be detected otherwise
-	 *
-	 * @param string $column
-	 * @param mixed $value
-	 * @return $this
-	 * @since 30.0.0
-	 */
-	public function hintShardKey(string $column, mixed $value, bool $overwrite = false): self;
-
-	/**
-	 * Set the query to run across all shards if sharding is enabled.
-	 *
-	 * @return $this
-	 * @since 30.0.0
-	 */
-	public function runAcrossAllShards(): self;
-
-	/**
-	 * Get a list of column names that are expected in the query output
-	 *
-	 * @return array
-	 * @since 30.0.0
-	 */
-	public function getOutputColumns(): array;
+    /**
+     * @since 9.0.0
+     */
+    public const PARAM_NULL = ParameterType::NULL;
+    /**
+     * @since 9.0.0
+     */
+    public const PARAM_BOOL = Types::BOOLEAN;
+    /**
+     * @since 9.0.0
+     */
+    public const PARAM_INT = ParameterType::INTEGER;
+    /**
+     * @since 9.0.0
+     */
+    public const PARAM_STR = ParameterType::STRING;
+    /**
+     * @since 9.0.0
+     */
+    public const PARAM_LOB = ParameterType::LARGE_OBJECT;
+
+    /**
+     * @since 9.0.0
+     * @deprecated 31.0.0 - use PARAM_DATETIME_MUTABLE instead
+     */
+    public const PARAM_DATE = Types::DATETIME_MUTABLE;
+
+    /**
+     * For passing a \DateTime instance when only interested in the time part (without timezone support)
+     * @since 31.0.0
+     */
+    public const PARAM_TIME_MUTABLE = Types::TIME_MUTABLE;
+
+    /**
+     * For passing a \DateTime instance when only interested in the date part (without timezone support)
+     * @since 31.0.0
+     */
+    public const PARAM_DATE_MUTABLE = Types::DATE_MUTABLE;
+
+    /**
+     * For passing a \DateTime instance (without timezone support)
+     * @since 31.0.0
+     */
+    public const PARAM_DATETIME_MUTABLE = Types::DATETIME_MUTABLE;
+
+    /**
+     * For passing a \DateTime instance with timezone support
+     * @since 31.0.0
+     */
+    public const PARAM_DATETIME_TZ_MUTABLE = Types::DATETIMETZ_MUTABLE;
+
+    /**
+     * For passing a \DateTimeImmutable instance when only interested in the time part (without timezone support)
+     * @since 31.0.0
+     */
+    public const PARAM_TIME_IMMUTABLE = Types::TIME_MUTABLE;
+
+    /**
+     * For passing a \DateTime instance when only interested in the date part (without timezone support)
+     * @since 9.0.0
+     */
+    public const PARAM_DATE_IMMUTABLE = Types::DATE_IMMUTABLE;
+
+    /**
+     * For passing a \DateTime instance (without timezone support)
+     * @since 31.0.0
+     */
+    public const PARAM_DATETIME_IMMUTABLE = Types::DATETIME_IMMUTABLE;
+
+    /**
+     * For passing a \DateTime instance with timezone support
+     * @since 31.0.0
+     */
+    public const PARAM_DATETIME_TZ_IMMUTABLE = Types::DATETIMETZ_IMMUTABLE;
+
+    /**
+     * @since 24.0.0
+     * @deprecated 33.0.0 JSON fields can not properly be used in WHERE statements of Oracle and MySQL.
+     *                    It is recommended to use a simple STRING field and handle JSON within PHP
+     */
+    public const PARAM_JSON = 'json';
+
+    /**
+     * @since 9.0.0
+     */
+    public const PARAM_INT_ARRAY = ArrayParameterType::INTEGER;
+    /**
+     * @since 9.0.0
+     */
+    public const PARAM_STR_ARRAY = ArrayParameterType::STRING;
+
+    /**
+     * @since 24.0.0 Indicates how many rows can be deleted at once with MySQL
+     * database server.
+     */
+    public const MAX_ROW_DELETION = 100000;
+
+    /**
+     * Enable/disable automatic prefixing of table names with the oc_ prefix
+     *
+     * @param bool $enabled If set to true table names will be prefixed with the
+     *                      owncloud database prefix automatically.
+     * @since 8.2.0
+     */
+    public function automaticTablePrefix($enabled);
+
+    /**
+     * Gets an ExpressionBuilder used for object-oriented construction of query expressions.
+     * This producer method is intended for convenient inline usage. Example:
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u')
+     *         ->from('users', 'u')
+     *         ->where($qb->expr()->eq('u.id', 1));
+     * </code>
+     *
+     * For more complex expression construction, consider storing the expression
+     * builder object in a local variable.
+     *
+     * @return \OCP\DB\QueryBuilder\IExpressionBuilder
+     * @since 8.2.0
+     */
+    public function expr();
+
+    /**
+     * Gets an FunctionBuilder used for object-oriented construction of query functions.
+     * This producer method is intended for convenient inline usage. Example:
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u')
+     *         ->from('users', 'u')
+     *         ->where($qb->fun()->md5('u.id'));
+     * </code>
+     *
+     * For more complex function construction, consider storing the function
+     * builder object in a local variable.
+     *
+     * @return \OCP\DB\QueryBuilder\IFunctionBuilder
+     * @since 12.0.0
+     */
+    public function func();
+
+    /**
+     * Gets the type of the currently built query.
+     *
+     * @return integer
+     * @since 8.2.0
+     */
+    public function getType();
+
+    /**
+     * Gets the associated DBAL Connection for this query builder.
+     *
+     * @return \OCP\IDBConnection
+     * @since 8.2.0
+     */
+    public function getConnection();
+
+    /**
+     * Gets the state of this query builder instance.
+     *
+     * @return integer Either QueryBuilder::STATE_DIRTY or QueryBuilder::STATE_CLEAN.
+     * @since 8.2.0
+     * @deprecated 30.0.0 This function is going to be removed with the next Doctrine/DBAL update
+     *    and we can not fix this in our wrapper.
+     */
+    public function getState();
+
+    /**
+     * Execute for select statements
+     *
+     * @param ?IDBConnection $connection (optional) the connection to run the query against. since 30.0
+     * @return IResult
+     * @since 22.0.0
+     *
+     * @throws Exception
+     * @throws \RuntimeException in case of usage with non select query
+     */
+    public function executeQuery(?IDBConnection $connection = null): IResult;
+
+    /**
+     * Execute insert, update and delete statements
+     *
+     * @param ?IDBConnection $connection (optional) the connection to run the query against. since 30.0
+     * @return int the number of affected rows
+     * @since 22.0.0
+     *
+     * @throws Exception
+     * @throws \RuntimeException in case of usage with select query
+     */
+    public function executeStatement(?IDBConnection $connection = null): int;
+
+    /**
+     * Gets the complete SQL string formed by the current specifications of this QueryBuilder.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u')
+     *         ->from('User', 'u')
+     *     echo $qb->getSQL(); // SELECT u FROM User u
+     * </code>
+     *
+     * @return string The SQL query string.
+     * @since 8.2.0
+     */
+    public function getSQL();
+
+    /**
+     * Sets a query parameter for the query being constructed.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u')
+     *         ->from('users', 'u')
+     *         ->where('u.id = :user_id')
+     *         ->setParameter(':user_id', 1);
+     * </code>
+     *
+     * @param string|integer $key The parameter position or name.
+     * @param mixed $value The parameter value.
+     * @param string|null|int $type One of the IQueryBuilder::PARAM_* constants.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     */
+    public function setParameter($key, $value, $type = null);
+
+    /**
+     * Sets a collection of query parameters for the query being constructed.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u')
+     *         ->from('users', 'u')
+     *         ->where('u.id = :user_id1 OR u.id = :user_id2')
+     *         ->setParameters(array(
+     *             ':user_id1' => 1,
+     *             ':user_id2' => 2
+     *         ));
+     * </code>
+     *
+     * @param array $params The query parameters to set.
+     * @param array $types The query parameters types to set.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     */
+    public function setParameters(array $params, array $types = []);
+
+    /**
+     * Gets all defined query parameters for the query being constructed indexed by parameter index or name.
+     *
+     * @return array The currently defined query parameters indexed by parameter index or name.
+     * @since 8.2.0
+     */
+    public function getParameters();
+
+    /**
+     * Gets a (previously set) query parameter of the query being constructed.
+     *
+     * @param mixed $key The key (index or name) of the bound parameter.
+     *
+     * @return mixed The value of the bound parameter.
+     * @since 8.2.0
+     */
+    public function getParameter($key);
+
+    /**
+     * Gets all defined query parameter types for the query being constructed indexed by parameter index or name.
+     *
+     * @return array The currently defined query parameter types indexed by parameter index or name.
+     * @since 8.2.0
+     */
+    public function getParameterTypes();
+
+    /**
+     * Gets a (previously set) query parameter type of the query being constructed.
+     *
+     * @param mixed $key The key (index or name) of the bound parameter type.
+     *
+     * @return mixed The value of the bound parameter type.
+     * @since 8.2.0
+     */
+    public function getParameterType($key);
+
+    /**
+     * Sets the position of the first result to retrieve (the "offset").
+     *
+     * @param int $firstResult The first result to return.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     */
+    public function setFirstResult($firstResult);
+
+    /**
+     * Gets the position of the first result the query object was set to retrieve (the "offset").
+     * Returns 0 if {@link setFirstResult} was not applied to this QueryBuilder.
+     *
+     * @return int The position of the first result.
+     * @since 8.2.0
+     */
+    public function getFirstResult();
+
+    /**
+     * Sets the maximum number of results to retrieve (the "limit").
+     *
+     * @param int|null $maxResults The maximum number of results to retrieve.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     */
+    public function setMaxResults($maxResults);
+
+    /**
+     * Gets the maximum number of results the query object was set to retrieve (the "limit").
+     * Returns NULL if {@link setMaxResults} was not applied to this query builder.
+     *
+     * @return int|null The maximum number of results.
+     * @since 8.2.0
+     */
+    public function getMaxResults();
+
+    /**
+     * Specifies an item that is to be returned in the query result.
+     * Replaces any previously specified selections, if any.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.id', 'p.id')
+     *         ->from('users', 'u')
+     *         ->leftJoin('u', 'phonenumbers', 'p', 'u.id = p.user_id');
+     * </code>
+     *
+     * @param mixed ...$selects The selection expressions.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $selects
+     */
+    public function select(...$selects);
+
+    /**
+     * Specifies an item that is to be returned with a different name in the query result.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->selectAlias('u.id', 'user_id')
+     *         ->from('users', 'u')
+     *         ->leftJoin('u', 'phonenumbers', 'p', 'u.id = p.user_id');
+     * </code>
+     *
+     * @param mixed $select The selection expressions.
+     * @param string $alias The column alias used in the constructed query.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.1
+     *
+     * @psalm-taint-sink sql $select
+     * @psalm-taint-sink sql $alias
+     */
+    public function selectAlias($select, $alias);
+
+    /**
+     * Specifies an item that is to be returned uniquely in the query result.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->selectDistinct('type')
+     *         ->from('users');
+     * </code>
+     *
+     * @param mixed $select The selection expressions.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 9.0.0
+     *
+     * @psalm-taint-sink sql $select
+     */
+    public function selectDistinct($select);
+
+    /**
+     * Adds an item that is to be returned in the query result.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.id')
+     *         ->addSelect('p.id')
+     *         ->from('users', 'u')
+     *         ->leftJoin('u', 'phonenumbers', 'u.id = p.user_id');
+     * </code>
+     *
+     * @param mixed ...$select The selection expression.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $select
+     */
+    public function addSelect(...$select);
+
+    /**
+     * Turns the query being built into a bulk delete query that ranges over
+     * a certain table.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->delete('users')
+     *         ->where('id = :user_id');
+     *         ->setParameter(':user_id', 1);
+     * </code>
+     *
+     * @param string $delete The table whose rows are subject to the deletion.
+     * @param string $alias The table alias used in the constructed query.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     * @since 30.0.0 Alias is deprecated and will no longer be used with the next Doctrine/DBAL update
+     *
+     * @psalm-taint-sink sql $delete
+     */
+    public function delete($delete = null, $alias = null);
+
+    /**
+     * Turns the query being built into a bulk update query that ranges over
+     * a certain table
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->update('users')
+     *         ->set('email', ':email')
+     *         ->where('id = :user_id');
+     *         ->setParameter(':user_id', 1);
+     * </code>
+     *
+     * @param string $update The table whose rows are subject to the update.
+     * @param string $alias The table alias used in the constructed query.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     * @since 30.0.0 Alias is deprecated and will no longer be used with the next Doctrine/DBAL update
+     *
+     * @psalm-taint-sink sql $update
+     */
+    public function update($update = null, $alias = null);
+
+    /**
+     * Turns the query being built into an insert query that inserts into
+     * a certain table
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->insert('users')
+     *         ->values(
+     *             array(
+     *                 'name' => '?',
+     *                 'password' => '?'
+     *             )
+     *         );
+     * </code>
+     *
+     * @param string $insert The table into which the rows should be inserted.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $insert
+     */
+    public function insert($insert = null);
+
+    /**
+     * Creates and adds a query root corresponding to the table identified by the
+     * given alias, forming a cartesian product with any existing query roots.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.id')
+     *         ->from('users', 'u')
+     * </code>
+     *
+     * @param string|IQueryFunction $from The table.
+     * @param string|null $alias The alias of the table.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $from
+     */
+    public function from($from, $alias = null);
+
+    /**
+     * Creates and adds a join to the query.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.name')
+     *         ->from('users', 'u')
+     *         ->join('u', 'phonenumbers', 'p', 'p.is_primary = 1');
+     * </code>
+     *
+     * @param string $fromAlias The alias that points to a from clause.
+     * @param string|IQueryFunction $join The table name to join.
+     * @param string $alias The alias of the join table.
+     * @param string|ICompositeExpression|null $condition The condition for the join.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $fromAlias
+     * @psalm-taint-sink sql $join
+     * @psalm-taint-sink sql $alias
+     * @psalm-taint-sink sql $condition
+     */
+    public function join($fromAlias, $join, $alias, $condition = null);
+
+    /**
+     * Creates and adds a join to the query.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.name')
+     *         ->from('users', 'u')
+     *         ->innerJoin('u', 'phonenumbers', 'p', 'p.is_primary = 1');
+     * </code>
+     *
+     * @param string $fromAlias The alias that points to a from clause.
+     * @param string|IQueryFunction $join The table name to join.
+     * @param string $alias The alias of the join table.
+     * @param string|ICompositeExpression|null $condition The condition for the join.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $fromAlias
+     * @psalm-taint-sink sql $join
+     * @psalm-taint-sink sql $alias
+     * @psalm-taint-sink sql $condition
+     */
+    public function innerJoin($fromAlias, $join, $alias, $condition = null);
+
+    /**
+     * Creates and adds a left join to the query.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.name')
+     *         ->from('users', 'u')
+     *         ->leftJoin('u', 'phonenumbers', 'p', 'p.is_primary = 1');
+     * </code>
+     *
+     * @param string $fromAlias The alias that points to a from clause.
+     * @param string|IQueryFunction $join The table name to join.
+     * @param string $alias The alias of the join table.
+     * @param string|ICompositeExpression|null $condition The condition for the join.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     * @since 30.0.0 Allow passing IQueryFunction as parameter for `$join` to allow join with a sub-query.
+     *
+     * @psalm-taint-sink sql $fromAlias
+     * @psalm-taint-sink sql $join
+     * @psalm-taint-sink sql $alias
+     * @psalm-taint-sink sql $condition
+     */
+    public function leftJoin($fromAlias, $join, $alias, $condition = null);
+
+    /**
+     * Creates and adds a right join to the query.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.name')
+     *         ->from('users', 'u')
+     *         ->rightJoin('u', 'phonenumbers', 'p', 'p.is_primary = 1');
+     * </code>
+     *
+     * @param string $fromAlias The alias that points to a from clause.
+     * @param string|IQueryFunction $join The table name to join.
+     * @param string $alias The alias of the join table.
+     * @param string|ICompositeExpression|null $condition The condition for the join.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $fromAlias
+     * @psalm-taint-sink sql $join
+     * @psalm-taint-sink sql $alias
+     * @psalm-taint-sink sql $condition
+     */
+    public function rightJoin($fromAlias, $join, $alias, $condition = null);
+
+    /**
+     * Sets a new value for a column in a bulk update query.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->update('users', 'u')
+     *         ->set('u.password', md5('password'))
+     *         ->where('u.id = ?');
+     * </code>
+     *
+     * @param string $key The column to set.
+     * @param ILiteral|IParameter|IQueryFunction|string $value The value, expression, placeholder, etc.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $key
+     * @psalm-taint-sink sql $value
+     */
+    public function set($key, $value);
+
+    /**
+     * Specifies one or more restrictions to the query result.
+     * Replaces any previously specified restrictions, if any.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.name')
+     *         ->from('users', 'u')
+     *         ->where('u.id = ?');
+     *
+     *     // You can optionally programmatically build and/or expressions
+     *     $qb = $conn->getQueryBuilder();
+     *
+     *     $or = $qb->expr()->orx(
+     *         $qb->expr()->eq('u.id', 1),
+     *         $qb->expr()->eq('u.id', 2),
+     *     );
+     *
+     *     $qb->update('users', 'u')
+     *         ->set('u.password', md5('password'))
+     *         ->where($or);
+     * </code>
+     *
+     * @param mixed $predicates The restriction predicates.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $predicates
+     */
+    public function where(...$predicates);
+
+    /**
+     * Adds one or more restrictions to the query results, forming a logical
+     * conjunction with any previously specified restrictions.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u')
+     *         ->from('users', 'u')
+     *         ->where('u.username LIKE ?')
+     *         ->andWhere('u.is_active = 1');
+     * </code>
+     *
+     * @param mixed ...$where The query restrictions.
+     *
+     * @return $this This QueryBuilder instance.
+     *
+     * @see where()
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $where
+     */
+    public function andWhere(...$where);
+
+    /**
+     * Adds one or more restrictions to the query results, forming a logical
+     * disjunction with any previously specified restrictions.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.name')
+     *         ->from('users', 'u')
+     *         ->where('u.id = 1')
+     *         ->orWhere('u.id = 2');
+     * </code>
+     *
+     * @param mixed ...$where The WHERE statement.
+     *
+     * @return $this This QueryBuilder instance.
+     *
+     * @see where()
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $where
+     */
+    public function orWhere(...$where);
+
+    /**
+     * Specifies a grouping over the results of the query.
+     * Replaces any previously specified groupings, if any.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.name')
+     *         ->from('users', 'u')
+     *         ->groupBy('u.id');
+     * </code>
+     *
+     * @param mixed ...$groupBys The grouping expression.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $groupBys
+     */
+    public function groupBy(...$groupBys);
+
+    /**
+     * Adds a grouping expression to the query.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->select('u.name')
+     *         ->from('users', 'u')
+     *         ->groupBy('u.lastLogin');
+     *         ->addGroupBy('u.createdAt')
+     * </code>
+     *
+     * @param mixed ...$groupBy The grouping expression.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $groupby
+     */
+    public function addGroupBy(...$groupBy);
+
+    /**
+     * Sets a value for a column in an insert query.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->insert('users')
+     *         ->values(
+     *             array(
+     *                 'name' => '?'
+     *             )
+     *         )
+     *         ->setValue('password', '?');
+     * </code>
+     *
+     * @param string $column The column into which the value should be inserted.
+     * @param IParameter|string $value The value that should be inserted into the column.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $column
+     * @psalm-taint-sink sql $value
+     */
+    public function setValue($column, $value);
+
+    /**
+     * Specifies values for an insert query indexed by column names.
+     * Replaces any previous values, if any.
+     *
+     * <code>
+     *     $qb = $conn->getQueryBuilder()
+     *         ->insert('users')
+     *         ->values(
+     *             array(
+     *                 'name' => '?',
+     *                 'password' => '?'
+     *             )
+     *         );
+     * </code>
+     *
+     * @param array $values The values to specify for the insert query indexed by column names.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $values
+     */
+    public function values(array $values);
+
+    /**
+     * Specifies a restriction over the groups of the query.
+     * Replaces any previous having restrictions, if any.
+     *
+     * @param mixed ...$having The restriction over the groups.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $having
+     */
+    public function having(...$having);
+
+    /**
+     * Adds a restriction over the groups of the query, forming a logical
+     * conjunction with any existing having restrictions.
+     *
+     * @param mixed ...$having The restriction to append.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $andHaving
+     */
+    public function andHaving(...$having);
+
+    /**
+     * Adds a restriction over the groups of the query, forming a logical
+     * disjunction with any existing having restrictions.
+     *
+     * @param mixed ...$having The restriction to add.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $having
+     */
+    public function orHaving(...$having);
+
+    /**
+     * Specifies an ordering for the query results.
+     * Replaces any previously specified orderings, if any.
+     *
+     * @param string|IQueryFunction|ILiteral|IParameter $sort The ordering expression.
+     * @param string $order The ordering direction.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $sort
+     * @psalm-taint-sink sql $order
+     */
+    public function orderBy($sort, $order = null);
+
+    /**
+     * Adds an ordering to the query results.
+     *
+     * @param string|ILiteral|IParameter|IQueryFunction $sort The ordering expression.
+     * @param string $order The ordering direction.
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $sort
+     * @psalm-taint-sink sql $order
+     */
+    public function addOrderBy($sort, $order = null);
+
+    /**
+     * Gets a query part by its name.
+     *
+     * @param string $queryPartName
+     *
+     * @return mixed
+     * @since 8.2.0
+     * @deprecated 30.0.0 This function is going to be removed with the next Doctrine/DBAL update
+     *  and we can not fix this in our wrapper. Please track the details you need, outside the object.
+     */
+    public function getQueryPart($queryPartName);
+
+    /**
+     * Gets all query parts.
+     *
+     * @return array
+     * @since 8.2.0
+     * @deprecated 30.0.0 This function is going to be removed with the next Doctrine/DBAL update
+     *  and we can not fix this in our wrapper. Please track the details you need, outside the object.
+     */
+    public function getQueryParts();
+
+    /**
+     * Resets SQL parts.
+     *
+     * @param array|null $queryPartNames
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     * @deprecated 30.0.0 This function is going to be removed with the next Doctrine/DBAL update
+     * and we can not fix this in our wrapper. Please create a new IQueryBuilder instead.
+     */
+    public function resetQueryParts($queryPartNames = null);
+
+    /**
+     * Resets a single SQL part.
+     *
+     * @param string $queryPartName
+     *
+     * @return $this This QueryBuilder instance.
+     * @since 8.2.0
+     * @deprecated 30.0.0 This function is going to be removed with the next Doctrine/DBAL update
+     *  and we can not fix this in our wrapper. Please create a new IQueryBuilder instead.
+     */
+    public function resetQueryPart($queryPartName);
+
+    /**
+     * Creates a new named parameter and bind the value $value to it.
+     *
+     * This method provides a shortcut for PDOStatement::bindValue
+     * when using prepared statements.
+     *
+     * The parameter $value specifies the value that you want to bind. If
+     * $placeholder is not provided bindValue() will automatically create a
+     * placeholder for you. An automatic placeholder will be of the name
+     * ':dcValue1', ':dcValue2' etc.
+     *
+     * For more information see {@link https://www.php.net/pdostatement-bindparam}
+     *
+     * Example:
+     * <code>
+     * $value = 2;
+     * $q->eq( 'id', $q->bindValue( $value ) );
+     * $stmt = $q->executeQuery(); // executed with 'id = 2'
+     * </code>
+     *
+     * @license New BSD License
+     * @link http://www.zetacomponents.org
+     *
+     * @param mixed $value
+     * @param self::PARAM_* $type
+     * @param string $placeHolder The name to bind with. The string must start with a colon ':'.
+     *
+     * @return IParameter
+     * @since 8.2.0
+     *
+     * @psalm-taint-escape sql
+     */
+    public function createNamedParameter($value, $type = self::PARAM_STR, $placeHolder = null);
+
+    /**
+     * Creates a new positional parameter and bind the given value to it.
+     *
+     * Attention: If you are using positional parameters with the query builder you have
+     * to be very careful to bind all parameters in the order they appear in the SQL
+     * statement , otherwise they get bound in the wrong order which can lead to serious
+     * bugs in your code.
+     *
+     * Example:
+     * <code>
+     *  $qb = $conn->getQueryBuilder();
+     *  $qb->select('u.*')
+     *     ->from('users', 'u')
+     *     ->where('u.username = ' . $qb->createPositionalParameter('Foo', IQueryBuilder::PARAM_STR))
+     *     ->orWhere('u.username = ' . $qb->createPositionalParameter('Bar', IQueryBuilder::PARAM_STR))
+     * </code>
+     *
+     * @param mixed $value
+     * @param self::PARAM_* $type
+     *
+     * @return IParameter
+     * @since 8.2.0
+     *
+     * @psalm-taint-escape sql
+     */
+    public function createPositionalParameter($value, $type = self::PARAM_STR);
+
+    /**
+     * Creates a new parameter
+     *
+     * Example:
+     * <code>
+     *  $qb = $conn->getQueryBuilder();
+     *  $qb->select('u.*')
+     *     ->from('users', 'u')
+     *     ->where('u.username = ' . $qb->createParameter('name'))
+     *     ->setParameter('name', 'Bar', IQueryBuilder::PARAM_STR))
+     * </code>
+     *
+     * @param string $name
+     *
+     * @return IParameter
+     * @since 8.2.0
+     *
+     * @psalm-taint-escape sql
+     */
+    public function createParameter($name);
+
+    /**
+     * Creates a new function
+     *
+     * Attention: Column names inside the call have to be quoted before hand
+     *
+     * Example:
+     * <code>
+     *  $qb = $conn->getQueryBuilder();
+     *  $qb->select($qb->createFunction('COUNT(*)'))
+     *     ->from('users', 'u')
+     *  echo $qb->getSQL(); // SELECT COUNT(*) FROM `users` u
+     * </code>
+     * <code>
+     *  $qb = $conn->getQueryBuilder();
+     *  $qb->select($qb->createFunction('COUNT(`column`)'))
+     *     ->from('users', 'u')
+     *  echo $qb->getSQL(); // SELECT COUNT(`column`) FROM `users` u
+     * </code>
+     *
+     * @param string $call
+     *
+     * @return IQueryFunction
+     * @since 8.2.0
+     *
+     * @psalm-taint-sink sql $call
+     */
+    public function createFunction($call);
+
+    /**
+     * Used to get the id of the last inserted element
+     * @return int
+     * @throws \BadMethodCallException When being called before an insert query has been run.
+     * @since 9.0.0
+     */
+    public function getLastInsertId(): int;
+
+    /**
+     * Returns the table name quoted and with database prefix as needed by the implementation.
+     * If a query function is passed the function is casted to string,
+     * this allows passing functions as sub-queries for join expression.
+     *
+     * @param string|IQueryFunction $table
+     * @return string
+     * @since 9.0.0
+     * @since 24.0.0 accepts IQueryFunction as parameter
+     */
+    public function getTableName($table);
+
+    /**
+     * Returns the table name with database prefix as needed by the implementation
+     *
+     * @param string $table
+     * @return string
+     * @since 30.0.0
+     */
+    public function prefixTableName(string $table): string;
+
+    /**
+     * Returns the column name quoted and with table alias prefix as needed by the implementation
+     *
+     * @param string $column
+     * @param string $tableAlias
+     * @return string
+     * @since 9.0.0
+     */
+    public function getColumnName($column, $tableAlias = '');
+
+    /**
+     * Provide a hint for the shard key for queries where this can't be detected otherwise
+     *
+     * @param string $column
+     * @param mixed $value
+     * @return $this
+     * @since 30.0.0
+     */
+    public function hintShardKey(string $column, mixed $value, bool $overwrite = false): self;
+
+    /**
+     * Set the query to run across all shards if sharding is enabled.
+     *
+     * @return $this
+     * @since 30.0.0
+     */
+    public function runAcrossAllShards(): self;
+
+    /**
+     * Get a list of column names that are expected in the query output
+     *
+     * @return array
+     * @since 30.0.0
+     */
+    public function getOutputColumns(): array;
 }

lib/private/DB/QueryBuilder/ExpressionBuilder/MySqlExpressionBuilder.php

Indentation +32 added lines, -32 removed lines

@@ -14,40 +14,40 @@
 use Psr\Log\LoggerInterface;
 
 class MySqlExpressionBuilder extends ExpressionBuilder {
-	protected string $collation;
+    protected string $collation;
 
-	public function __construct(ConnectionAdapter $connection, IQueryBuilder $queryBuilder, LoggerInterface $logger) {
-		parent::__construct($connection, $queryBuilder, $logger);
+    public function __construct(ConnectionAdapter $connection, IQueryBuilder $queryBuilder, LoggerInterface $logger) {
+        parent::__construct($connection, $queryBuilder, $logger);
 
-		$params = $connection->getInner()->getParams();
-		$this->collation = $params['collation'] ?? (($params['charset'] ?? 'utf8') . '_general_ci');
-	}
+        $params = $connection->getInner()->getParams();
+        $this->collation = $params['collation'] ?? (($params['charset'] ?? 'utf8') . '_general_ci');
+    }
 
-	/**
-	 * @inheritdoc
-	 */
-	public function iLike($x, $y, $type = null): string {
-		$x = $this->helper->quoteColumnName($x);
-		$y = $this->helper->quoteColumnName($y);
-		return $this->expressionBuilder->comparison($x, ' COLLATE ' . $this->collation . ' LIKE', $y);
-	}
+    /**
+     * @inheritdoc
+     */
+    public function iLike($x, $y, $type = null): string {
+        $x = $this->helper->quoteColumnName($x);
+        $y = $this->helper->quoteColumnName($y);
+        return $this->expressionBuilder->comparison($x, ' COLLATE ' . $this->collation . ' LIKE', $y);
+    }
 
-	/**
-	 * Returns a IQueryFunction that casts the column to the given type
-	 *
-	 * @param string|IQueryFunction $column
-	 * @param mixed $type One of IQueryBuilder::PARAM_*
-	 * @psalm-param IQueryBuilder::PARAM_* $type
-	 * @return IQueryFunction
-	 */
-	public function castColumn($column, $type): IQueryFunction {
-		switch ($type) {
-			case IQueryBuilder::PARAM_STR:
-				return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS CHAR)');
-			case IQueryBuilder::PARAM_JSON:
-				return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS JSON)');
-			default:
-				return parent::castColumn($column, $type);
-		}
-	}
+    /**
+     * Returns a IQueryFunction that casts the column to the given type
+     *
+     * @param string|IQueryFunction $column
+     * @param mixed $type One of IQueryBuilder::PARAM_*
+     * @psalm-param IQueryBuilder::PARAM_* $type
+     * @return IQueryFunction
+     */
+    public function castColumn($column, $type): IQueryFunction {
+        switch ($type) {
+            case IQueryBuilder::PARAM_STR:
+                return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS CHAR)');
+            case IQueryBuilder::PARAM_JSON:
+                return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS JSON)');
+            default:
+                return parent::castColumn($column, $type);
+        }
+    }
 }

Spacing +4 added lines, -4 removed lines

@@ -20,7 +20,7 @@ 
 		parent::__construct($connection, $queryBuilder, $logger);
 
 		$params = $connection->getInner()->getParams();
-		$this->collation = $params['collation'] ?? (($params['charset'] ?? 'utf8') . '_general_ci');
+		$this->collation = $params['collation'] ?? (($params['charset'] ?? 'utf8').'_general_ci');
 	}
 
 	/**
@@ -29,7 +29,7 @@ 
 	public function iLike($x, $y, $type = null): string {
 		$x = $this->helper->quoteColumnName($x);
 		$y = $this->helper->quoteColumnName($y);
-		return $this->expressionBuilder->comparison($x, ' COLLATE ' . $this->collation . ' LIKE', $y);
+		return $this->expressionBuilder->comparison($x, ' COLLATE '.$this->collation.' LIKE', $y);
 	}
 
 	/**
@@ -43,9 +43,9 @@ 
 	public function castColumn($column, $type): IQueryFunction {
 		switch ($type) {
 			case IQueryBuilder::PARAM_STR:
-				return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS CHAR)');
+				return new QueryFunction('CAST('.$this->helper->quoteColumnName($column).' AS CHAR)');
 			case IQueryBuilder::PARAM_JSON:
-				return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS JSON)');
+				return new QueryFunction('CAST('.$this->helper->quoteColumnName($column).' AS JSON)');
 			default:
 				return parent::castColumn($column, $type);
 		}

lib/private/DB/QueryBuilder/ExpressionBuilder/PgSqlExpressionBuilder.php

Indentation +36 added lines, -36 removed lines

@@ -14,43 +14,43 @@
 use OCP\DB\QueryBuilder\IQueryFunction;
 
 class PgSqlExpressionBuilder extends ExpressionBuilder {
-	/**
-	 * Returns a IQueryFunction that casts the column to the given type
-	 *
-	 * @param string|IQueryFunction $column
-	 * @param mixed $type One of IQueryBuilder::PARAM_*
-	 * @psalm-param IQueryBuilder::PARAM_* $type
-	 * @return IQueryFunction
-	 */
-	public function castColumn($column, $type): IQueryFunction {
-		switch ($type) {
-			case IQueryBuilder::PARAM_INT:
-				return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS BIGINT)');
-			case IQueryBuilder::PARAM_STR:
-			case IQueryBuilder::PARAM_JSON:
-				return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS TEXT)');
-			default:
-				return parent::castColumn($column, $type);
-		}
-	}
+    /**
+     * Returns a IQueryFunction that casts the column to the given type
+     *
+     * @param string|IQueryFunction $column
+     * @param mixed $type One of IQueryBuilder::PARAM_*
+     * @psalm-param IQueryBuilder::PARAM_* $type
+     * @return IQueryFunction
+     */
+    public function castColumn($column, $type): IQueryFunction {
+        switch ($type) {
+            case IQueryBuilder::PARAM_INT:
+                return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS BIGINT)');
+            case IQueryBuilder::PARAM_STR:
+            case IQueryBuilder::PARAM_JSON:
+                return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS TEXT)');
+            default:
+                return parent::castColumn($column, $type);
+        }
+    }
 
-	/**
-	 * @inheritdoc
-	 */
-	protected function prepareColumn($column, $type) {
-		if ($type === IQueryBuilder::PARAM_JSON && !is_array($column) && !($column instanceof IParameter) && !($column instanceof ILiteral)) {
-			$column = $this->castColumn($column, $type);
-		}
+    /**
+     * @inheritdoc
+     */
+    protected function prepareColumn($column, $type) {
+        if ($type === IQueryBuilder::PARAM_JSON && !is_array($column) && !($column instanceof IParameter) && !($column instanceof ILiteral)) {
+            $column = $this->castColumn($column, $type);
+        }
 
-		return parent::prepareColumn($column, $type);
-	}
+        return parent::prepareColumn($column, $type);
+    }
 
-	/**
-	 * @inheritdoc
-	 */
-	public function iLike($x, $y, $type = null): string {
-		$x = $this->helper->quoteColumnName($x);
-		$y = $this->helper->quoteColumnName($y);
-		return $this->expressionBuilder->comparison($x, 'ILIKE', $y);
-	}
+    /**
+     * @inheritdoc
+     */
+    public function iLike($x, $y, $type = null): string {
+        $x = $this->helper->quoteColumnName($x);
+        $y = $this->helper->quoteColumnName($y);
+        return $this->expressionBuilder->comparison($x, 'ILIKE', $y);
+    }
 }

Spacing +2 added lines, -2 removed lines

@@ -25,10 +25,10 @@
 	public function castColumn($column, $type): IQueryFunction {
 		switch ($type) {
 			case IQueryBuilder::PARAM_INT:
-				return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS BIGINT)');
+				return new QueryFunction('CAST('.$this->helper->quoteColumnName($column).' AS BIGINT)');
 			case IQueryBuilder::PARAM_STR:
 			case IQueryBuilder::PARAM_JSON:
-				return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS TEXT)');
+				return new QueryFunction('CAST('.$this->helper->quoteColumnName($column).' AS TEXT)');
 			default:
 				return parent::castColumn($column, $type);
 		}

lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php

Indentation +115 added lines, -115 removed lines

@@ -14,119 +14,119 @@
 use OCP\DB\QueryBuilder\IQueryFunction;
 
 class OCIExpressionBuilder extends ExpressionBuilder {
-	/**
-	 * @param mixed $column
-	 * @param mixed|null $type
-	 * @return array|IQueryFunction|string
-	 */
-	protected function prepareColumn($column, $type) {
-		if ($type === IQueryBuilder::PARAM_STR && !is_array($column) && !($column instanceof IParameter) && !($column instanceof ILiteral)) {
-			$column = $this->castColumn($column, $type);
-		}
-
-		return parent::prepareColumn($column, $type);
-	}
-
-	/**
-	 * @inheritdoc
-	 */
-	public function eq($x, $y, $type = null): string {
-		if ($type === IQueryBuilder::PARAM_JSON) {
-			$x = $this->prepareColumn($x, $type);
-			$y = $this->prepareColumn($y, $type);
-			return (string)(new QueryFunction('JSON_EQUAL(' . $x . ',' . $y . ')'));
-		}
-
-		return parent::eq($x, $y, $type);
-	}
-
-	/**
-	 * @inheritdoc
-	 */
-	public function neq($x, $y, $type = null): string {
-		if ($type === IQueryBuilder::PARAM_JSON) {
-			$x = $this->prepareColumn($x, $type);
-			$y = $this->prepareColumn($y, $type);
-			return (string)(new QueryFunction('NOT JSON_EQUAL(' . $x . ',' . $y . ')'));
-		}
-
-		return parent::neq($x, $y, $type);
-	}
-
-	/**
-	 * @inheritdoc
-	 */
-	public function in($x, $y, $type = null): string {
-		$x = $this->prepareColumn($x, $type);
-		$y = $this->prepareColumn($y, $type);
-
-		return $this->expressionBuilder->in($x, $y);
-	}
-
-	/**
-	 * @inheritdoc
-	 */
-	public function notIn($x, $y, $type = null): string {
-		$x = $this->prepareColumn($x, $type);
-		$y = $this->prepareColumn($y, $type);
-
-		return $this->expressionBuilder->notIn($x, $y);
-	}
-
-	/**
-	 * Creates a $x = '' statement, because Oracle needs a different check
-	 *
-	 * @param string|ILiteral|IParameter|IQueryFunction $x The field in string format to be inspected by the comparison.
-	 * @return string
-	 * @since 13.0.0
-	 */
-	public function emptyString($x): string {
-		return $this->isNull($x);
-	}
-
-	/**
-	 * Creates a `$x <> ''` statement, because Oracle needs a different check
-	 *
-	 * @param string|ILiteral|IParameter|IQueryFunction $x The field in string format to be inspected by the comparison.
-	 * @return string
-	 * @since 13.0.0
-	 */
-	public function nonEmptyString($x): string {
-		return $this->isNotNull($x);
-	}
-
-	/**
-	 * Returns a IQueryFunction that casts the column to the given type
-	 *
-	 * @param string|IQueryFunction $column
-	 * @param mixed $type One of IQueryBuilder::PARAM_*
-	 * @psalm-param IQueryBuilder::PARAM_* $type
-	 * @return IQueryFunction
-	 */
-	public function castColumn($column, $type): IQueryFunction {
-		if ($type === IQueryBuilder::PARAM_STR) {
-			$column = $this->helper->quoteColumnName($column);
-			return new QueryFunction('to_char(' . $column . ')');
-		}
-		if ($type === IQueryBuilder::PARAM_INT) {
-			$column = $this->helper->quoteColumnName($column);
-			return new QueryFunction('to_number(to_char(' . $column . '))');
-		}
-
-		return parent::castColumn($column, $type);
-	}
-
-	/**
-	 * @inheritdoc
-	 */
-	public function like($x, $y, $type = null): string {
-		return parent::like($x, $y, $type) . " ESCAPE '\\'";
-	}
-
-	/**
-	 * @inheritdoc
-	 */
-	public function iLike($x, $y, $type = null): string {
-		return $this->like($this->functionBuilder->lower($x), $this->functionBuilder->lower($y));
-	}
+    /**
+     * @param mixed $column
+     * @param mixed|null $type
+     * @return array|IQueryFunction|string
+     */
+    protected function prepareColumn($column, $type) {
+        if ($type === IQueryBuilder::PARAM_STR && !is_array($column) && !($column instanceof IParameter) && !($column instanceof ILiteral)) {
+            $column = $this->castColumn($column, $type);
+        }
+
+        return parent::prepareColumn($column, $type);
+    }
+
+    /**
+     * @inheritdoc
+     */
+    public function eq($x, $y, $type = null): string {
+        if ($type === IQueryBuilder::PARAM_JSON) {
+            $x = $this->prepareColumn($x, $type);
+            $y = $this->prepareColumn($y, $type);
+            return (string)(new QueryFunction('JSON_EQUAL(' . $x . ',' . $y . ')'));
+        }
+
+        return parent::eq($x, $y, $type);
+    }
+
+    /**
+     * @inheritdoc
+     */
+    public function neq($x, $y, $type = null): string {
+        if ($type === IQueryBuilder::PARAM_JSON) {
+            $x = $this->prepareColumn($x, $type);
+            $y = $this->prepareColumn($y, $type);
+            return (string)(new QueryFunction('NOT JSON_EQUAL(' . $x . ',' . $y . ')'));
+        }
+
+        return parent::neq($x, $y, $type);
+    }
+
+    /**
+     * @inheritdoc
+     */
+    public function in($x, $y, $type = null): string {
+        $x = $this->prepareColumn($x, $type);
+        $y = $this->prepareColumn($y, $type);
+
+        return $this->expressionBuilder->in($x, $y);
+    }
+
+    /**
+     * @inheritdoc
+     */
+    public function notIn($x, $y, $type = null): string {
+        $x = $this->prepareColumn($x, $type);
+        $y = $this->prepareColumn($y, $type);
+
+        return $this->expressionBuilder->notIn($x, $y);
+    }
+
+    /**
+     * Creates a $x = '' statement, because Oracle needs a different check
+     *
+     * @param string|ILiteral|IParameter|IQueryFunction $x The field in string format to be inspected by the comparison.
+     * @return string
+     * @since 13.0.0
+     */
+    public function emptyString($x): string {
+        return $this->isNull($x);
+    }
+
+    /**
+     * Creates a `$x <> ''` statement, because Oracle needs a different check
+     *
+     * @param string|ILiteral|IParameter|IQueryFunction $x The field in string format to be inspected by the comparison.
+     * @return string
+     * @since 13.0.0
+     */
+    public function nonEmptyString($x): string {
+        return $this->isNotNull($x);
+    }
+
+    /**
+     * Returns a IQueryFunction that casts the column to the given type
+     *
+     * @param string|IQueryFunction $column
+     * @param mixed $type One of IQueryBuilder::PARAM_*
+     * @psalm-param IQueryBuilder::PARAM_* $type
+     * @return IQueryFunction
+     */
+    public function castColumn($column, $type): IQueryFunction {
+        if ($type === IQueryBuilder::PARAM_STR) {
+            $column = $this->helper->quoteColumnName($column);
+            return new QueryFunction('to_char(' . $column . ')');
+        }
+        if ($type === IQueryBuilder::PARAM_INT) {
+            $column = $this->helper->quoteColumnName($column);
+            return new QueryFunction('to_number(to_char(' . $column . '))');
+        }
+
+        return parent::castColumn($column, $type);
+    }
+
+    /**
+     * @inheritdoc
+     */
+    public function like($x, $y, $type = null): string {
+        return parent::like($x, $y, $type) . " ESCAPE '\\'";
+    }
+
+    /**
+     * @inheritdoc
+     */
+    public function iLike($x, $y, $type = null): string {
+        return $this->like($this->functionBuilder->lower($x), $this->functionBuilder->lower($y));
+    }
 }

Spacing +5 added lines, -5 removed lines

@@ -34,7 +34,7 @@ 
 		if ($type === IQueryBuilder::PARAM_JSON) {
 			$x = $this->prepareColumn($x, $type);
 			$y = $this->prepareColumn($y, $type);
-			return (string)(new QueryFunction('JSON_EQUAL(' . $x . ',' . $y . ')'));
+			return (string) (new QueryFunction('JSON_EQUAL('.$x.','.$y.')'));
 		}
 
 		return parent::eq($x, $y, $type);
@@ -47,7 +47,7 @@ 
 		if ($type === IQueryBuilder::PARAM_JSON) {
 			$x = $this->prepareColumn($x, $type);
 			$y = $this->prepareColumn($y, $type);
-			return (string)(new QueryFunction('NOT JSON_EQUAL(' . $x . ',' . $y . ')'));
+			return (string) (new QueryFunction('NOT JSON_EQUAL('.$x.','.$y.')'));
 		}
 
 		return parent::neq($x, $y, $type);
@@ -106,11 +106,11 @@ 
 	public function castColumn($column, $type): IQueryFunction {
 		if ($type === IQueryBuilder::PARAM_STR) {
 			$column = $this->helper->quoteColumnName($column);
-			return new QueryFunction('to_char(' . $column . ')');
+			return new QueryFunction('to_char('.$column.')');
 		}
 		if ($type === IQueryBuilder::PARAM_INT) {
 			$column = $this->helper->quoteColumnName($column);
-			return new QueryFunction('to_number(to_char(' . $column . '))');
+			return new QueryFunction('to_number(to_char('.$column.'))');
 		}
 
 		return parent::castColumn($column, $type);
@@ -120,7 +120,7 @@ 
 	 * @inheritdoc
 	 */
 	public function like($x, $y, $type = null): string {
-		return parent::like($x, $y, $type) . " ESCAPE '\\'";
+		return parent::like($x, $y, $type)." ESCAPE '\\'";
 	}
 
 	/**

tests/lib/DB/QueryBuilder/ExpressionBuilderDBTest.php

Indentation +262 added lines, -262 removed lines

@@ -18,266 +18,266 @@
 
 #[\PHPUnit\Framework\Attributes\Group('DB')]
 class ExpressionBuilderDBTest extends TestCase {
-	/** @var \Doctrine\DBAL\Connection|IDBConnection */
-	protected $connection;
-	protected $schemaSetup = false;
-
-	protected function setUp(): void {
-		parent::setUp();
-
-		$this->connection = Server::get(IDBConnection::class);
-		$this->prepareTestingTable();
-	}
-
-	public static function likeProvider(): array {
-		$connection = Server::get(IDBConnection::class);
-
-		return [
-			['foo', 'bar', false],
-			['foo', 'foo', true],
-			['foo', 'f%', true],
-			['foo', '%o', true],
-			['foo', '%', true],
-			['foo', 'fo_', true],
-			['foo', 'foo_', false],
-			['foo', $connection->escapeLikeParameter('fo_'), false],
-			['foo', $connection->escapeLikeParameter('f%'), false],
-		];
-	}
-
-	/**
-	 *
-	 * @param string $param1
-	 * @param string $param2
-	 * @param boolean $match
-	 */
-	#[\PHPUnit\Framework\Attributes\DataProvider('likeProvider')]
-	public function testLike($param1, $param2, $match): void {
-		$query = $this->connection->getQueryBuilder();
-
-		$query->select(new Literal('1'))
-			->from('users')
-			->where($query->expr()->like($query->createNamedParameter($param1), $query->createNamedParameter($param2)));
-
-		$result = $query->executeQuery();
-		$column = $result->fetchOne();
-		$result->closeCursor();
-		$this->assertEquals($match, $column);
-	}
-
-	public static function ilikeProvider(): array {
-		$connection = Server::get(IDBConnection::class);
-
-		return [
-			['foo', 'bar', false],
-			['foo', 'foo', true],
-			['foo', 'Foo', true],
-			['foo', 'f%', true],
-			['foo', '%o', true],
-			['foo', '%', true],
-			['foo', 'fo_', true],
-			['foo', 'foo_', false],
-			['foo', $connection->escapeLikeParameter('fo_'), false],
-			['foo', $connection->escapeLikeParameter('f%'), false],
-		];
-	}
-
-	/**
-	 *
-	 * @param string $param1
-	 * @param string $param2
-	 * @param boolean $match
-	 */
-	#[\PHPUnit\Framework\Attributes\DataProvider('ilikeProvider')]
-	public function testILike($param1, $param2, $match): void {
-		$query = $this->connection->getQueryBuilder();
-
-		$query->select(new Literal('1'))
-			->from('users')
-			->where($query->expr()->iLike($query->createNamedParameter($param1), $query->createNamedParameter($param2)));
-
-		$result = $query->executeQuery();
-		$column = $result->fetchOne();
-		$result->closeCursor();
-		$this->assertEquals($match, $column);
-	}
-
-	public function testCastColumn(): void {
-		$appId = $this->getUniqueID('testing');
-		$this->createConfig($appId, '1', '4');
-
-		$query = $this->connection->getQueryBuilder();
-		$query->update('appconfig')
-			->set('configvalue',
-				$query->expr()->castColumn(
-					$query->createFunction(
-						'(' . $query->expr()->castColumn('configvalue', IQueryBuilder::PARAM_INT)
-						. ' + 1)'
-					), IQueryBuilder::PARAM_STR
-				)
-			)
-			->where($query->expr()->eq('appid', $query->createNamedParameter($appId)))
-			->andWhere($query->expr()->eq('configkey', $query->createNamedParameter('1')));
-
-		$result = $query->executeStatement();
-		$this->assertEquals(1, $result);
-	}
-
-	public function testLongText(): void {
-		$appId = $this->getUniqueID('testing');
-		$this->createConfig($appId, 'mykey', 'myvalue');
-
-		$query = $this->connection->getQueryBuilder();
-		$query->select('*')
-			->from('appconfig')
-			->where($query->expr()->eq('appid', $query->createNamedParameter($appId)))
-			->andWhere($query->expr()->eq('configkey', $query->createNamedParameter('mykey')))
-			->andWhere($query->expr()->eq('configvalue', $query->createNamedParameter('myvalue', IQueryBuilder::PARAM_STR), IQueryBuilder::PARAM_STR));
-
-		$result = $query->executeQuery();
-		$entries = $result->fetchAll();
-		$result->closeCursor();
-		self::assertCount(1, $entries);
-		self::assertEquals('myvalue', $entries[0]['configvalue']);
-	}
-
-	public function testJson(): void {
-		if ($this->connection->getDatabaseProvider(true) === IDBConnection::PLATFORM_ORACLE) {
-			$result = $this->connection->executeQuery('SELECT VERSION FROM PRODUCT_COMPONENT_VERSION');
-			$version = $result->fetchOne();
-			$result->closeCursor();
-			if (str_starts_with($version, '11.')) {
-				$this->markTestSkipped('JSON is not supported on Oracle 11, skipping until deprecation was clarified: ' . $version);
-			}
-		}
-
-
-		$appId = $this->getUniqueID('testing');
-		$query = $this->connection->getQueryBuilder();
-		$query->insert('share')
-			->values([
-				'uid_owner' => $query->createNamedParameter('uid_owner'),
-				'item_type' => $query->createNamedParameter('item_type'),
-				'permissions' => $query->createNamedParameter(0),
-				'stime' => $query->createNamedParameter(0),
-				'accepted' => $query->createNamedParameter(0),
-				'mail_send' => $query->createNamedParameter(0),
-				'share_type' => $query->createNamedParameter(0),
-				'share_with' => $query->createNamedParameter($appId),
-				'attributes' => $query->createNamedParameter('[["permissions","before"]]'),
-			])
-			->executeStatement();
-
-		$query = $this->connection->getQueryBuilder();
-		$query->update('share')
-			->set('attributes', $query->createNamedParameter('[["permissions","after"]]'));
-		if ($this->connection->getDatabaseProvider(true) === IDBConnection::PLATFORM_MYSQL) {
-			$query->where($query->expr()->eq('attributes', $query->createFunction("JSON_ARRAY(JSON_ARRAY('permissions','before'))"), IQueryBuilder::PARAM_JSON));
-		} else {
-			$query->where($query->expr()->eq('attributes', $query->createNamedParameter('[["permissions","before"]]'), IQueryBuilder::PARAM_JSON));
-		}
-		$query->executeStatement();
-
-		$query = $this->connection->getQueryBuilder();
-		$query->select('attributes')
-			->from('share')
-			->where($query->expr()->eq('share_with', $query->createNamedParameter($appId)));
-
-		$result = $query->executeQuery();
-		$entries = $result->fetchAll();
-		$result->closeCursor();
-		self::assertCount(1, $entries);
-		self::assertEquals([['permissions','after']], json_decode($entries[0]['attributes'], true));
-	}
-
-	public function testDateTimeEquals(): void {
-		$dateTime = new \DateTime('2023-01-01');
-		$insert = $this->connection->getQueryBuilder();
-		$insert->insert('testing')
-			->values(['datetime' => $insert->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATETIME_MUTABLE)])
-			->executeStatement();
-
-		$query = $this->connection->getQueryBuilder();
-		$result = $query->select('*')
-			->from('testing')
-			->where($query->expr()->eq('datetime', $query->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATETIME_MUTABLE)))
-			->executeQuery();
-		$entries = $result->fetchAll();
-		$result->closeCursor();
-		self::assertCount(1, $entries);
-	}
-
-	public function testDateTimeLess(): void {
-		$dateTime = new \DateTime('2022-01-01');
-		$dateTimeCompare = new \DateTime('2022-01-02');
-		$insert = $this->connection->getQueryBuilder();
-		$insert->insert('testing')
-			->values(['datetime' => $insert->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATETIME_MUTABLE)])
-			->executeStatement();
-
-		$query = $this->connection->getQueryBuilder();
-		$result = $query->select('*')
-			->from('testing')
-			->where($query->expr()->lt('datetime', $query->createNamedParameter($dateTimeCompare, IQueryBuilder::PARAM_DATETIME_MUTABLE)))
-			->executeQuery();
-		$entries = $result->fetchAll();
-		$result->closeCursor();
-		self::assertCount(1, $entries);
-	}
-
-	public function testDateTimeGreater(): void {
-		$dateTime = new \DateTime('2023-01-02');
-		$dateTimeCompare = new \DateTime('2023-01-01');
-		$insert = $this->connection->getQueryBuilder();
-		$insert->insert('testing')
-			->values(['datetime' => $insert->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATETIME_MUTABLE)])
-			->executeStatement();
-
-		$query = $this->connection->getQueryBuilder();
-		$result = $query->select('*')
-			->from('testing')
-			->where($query->expr()->gt('datetime', $query->createNamedParameter($dateTimeCompare, IQueryBuilder::PARAM_DATETIME_MUTABLE)))
-			->executeQuery();
-		$entries = $result->fetchAll();
-		$result->closeCursor();
-		self::assertCount(1, $entries);
-	}
-
-	protected function createConfig($appId, $key, $value) {
-		$query = $this->connection->getQueryBuilder();
-		$query->insert('appconfig')
-			->values([
-				'appid' => $query->createNamedParameter($appId),
-				'configkey' => $query->createNamedParameter((string)$key),
-				'configvalue' => $query->createNamedParameter((string)$value),
-			])
-			->executeStatement();
-	}
-
-	protected function prepareTestingTable(): void {
-		if ($this->schemaSetup) {
-			$this->connection->getQueryBuilder()->delete('testing')->executeStatement();
-		}
-
-		$prefix = Server::get(IConfig::class)->getSystemValueString('dbtableprefix', 'oc_');
-		$schema = $this->connection->createSchema();
-		try {
-			$schema->getTable($prefix . 'testing');
-			$this->connection->getQueryBuilder()->delete('testing')->executeStatement();
-		} catch (SchemaException $e) {
-			$this->schemaSetup = true;
-			$table = $schema->createTable($prefix . 'testing');
-			$table->addColumn('id', Types::BIGINT, [
-				'autoincrement' => true,
-				'notnull' => true,
-			]);
-
-			$table->addColumn('datetime', Types::DATETIME, [
-				'notnull' => false,
-			]);
-
-			$table->setPrimaryKey(['id']);
-			$this->connection->migrateToSchema($schema);
-		}
-	}
+    /** @var \Doctrine\DBAL\Connection|IDBConnection */
+    protected $connection;
+    protected $schemaSetup = false;
+
+    protected function setUp(): void {
+        parent::setUp();
+
+        $this->connection = Server::get(IDBConnection::class);
+        $this->prepareTestingTable();
+    }
+
+    public static function likeProvider(): array {
+        $connection = Server::get(IDBConnection::class);
+
+        return [
+            ['foo', 'bar', false],
+            ['foo', 'foo', true],
+            ['foo', 'f%', true],
+            ['foo', '%o', true],
+            ['foo', '%', true],
+            ['foo', 'fo_', true],
+            ['foo', 'foo_', false],
+            ['foo', $connection->escapeLikeParameter('fo_'), false],
+            ['foo', $connection->escapeLikeParameter('f%'), false],
+        ];
+    }
+
+    /**
+     *
+     * @param string $param1
+     * @param string $param2
+     * @param boolean $match
+     */
+    #[\PHPUnit\Framework\Attributes\DataProvider('likeProvider')]
+    public function testLike($param1, $param2, $match): void {
+        $query = $this->connection->getQueryBuilder();
+
+        $query->select(new Literal('1'))
+            ->from('users')
+            ->where($query->expr()->like($query->createNamedParameter($param1), $query->createNamedParameter($param2)));
+
+        $result = $query->executeQuery();
+        $column = $result->fetchOne();
+        $result->closeCursor();
+        $this->assertEquals($match, $column);
+    }
+
+    public static function ilikeProvider(): array {
+        $connection = Server::get(IDBConnection::class);
+
+        return [
+            ['foo', 'bar', false],
+            ['foo', 'foo', true],
+            ['foo', 'Foo', true],
+            ['foo', 'f%', true],
+            ['foo', '%o', true],
+            ['foo', '%', true],
+            ['foo', 'fo_', true],
+            ['foo', 'foo_', false],
+            ['foo', $connection->escapeLikeParameter('fo_'), false],
+            ['foo', $connection->escapeLikeParameter('f%'), false],
+        ];
+    }
+
+    /**
+     *
+     * @param string $param1
+     * @param string $param2
+     * @param boolean $match
+     */
+    #[\PHPUnit\Framework\Attributes\DataProvider('ilikeProvider')]
+    public function testILike($param1, $param2, $match): void {
+        $query = $this->connection->getQueryBuilder();
+
+        $query->select(new Literal('1'))
+            ->from('users')
+            ->where($query->expr()->iLike($query->createNamedParameter($param1), $query->createNamedParameter($param2)));
+
+        $result = $query->executeQuery();
+        $column = $result->fetchOne();
+        $result->closeCursor();
+        $this->assertEquals($match, $column);
+    }
+
+    public function testCastColumn(): void {
+        $appId = $this->getUniqueID('testing');
+        $this->createConfig($appId, '1', '4');
+
+        $query = $this->connection->getQueryBuilder();
+        $query->update('appconfig')
+            ->set('configvalue',
+                $query->expr()->castColumn(
+                    $query->createFunction(
+                        '(' . $query->expr()->castColumn('configvalue', IQueryBuilder::PARAM_INT)
+                        . ' + 1)'
+                    ), IQueryBuilder::PARAM_STR
+                )
+            )
+            ->where($query->expr()->eq('appid', $query->createNamedParameter($appId)))
+            ->andWhere($query->expr()->eq('configkey', $query->createNamedParameter('1')));
+
+        $result = $query->executeStatement();
+        $this->assertEquals(1, $result);
+    }
+
+    public function testLongText(): void {
+        $appId = $this->getUniqueID('testing');
+        $this->createConfig($appId, 'mykey', 'myvalue');
+
+        $query = $this->connection->getQueryBuilder();
+        $query->select('*')
+            ->from('appconfig')
+            ->where($query->expr()->eq('appid', $query->createNamedParameter($appId)))
+            ->andWhere($query->expr()->eq('configkey', $query->createNamedParameter('mykey')))
+            ->andWhere($query->expr()->eq('configvalue', $query->createNamedParameter('myvalue', IQueryBuilder::PARAM_STR), IQueryBuilder::PARAM_STR));
+
+        $result = $query->executeQuery();
+        $entries = $result->fetchAll();
+        $result->closeCursor();
+        self::assertCount(1, $entries);
+        self::assertEquals('myvalue', $entries[0]['configvalue']);
+    }
+
+    public function testJson(): void {
+        if ($this->connection->getDatabaseProvider(true) === IDBConnection::PLATFORM_ORACLE) {
+            $result = $this->connection->executeQuery('SELECT VERSION FROM PRODUCT_COMPONENT_VERSION');
+            $version = $result->fetchOne();
+            $result->closeCursor();
+            if (str_starts_with($version, '11.')) {
+                $this->markTestSkipped('JSON is not supported on Oracle 11, skipping until deprecation was clarified: ' . $version);
+            }
+        }
+
+
+        $appId = $this->getUniqueID('testing');
+        $query = $this->connection->getQueryBuilder();
+        $query->insert('share')
+            ->values([
+                'uid_owner' => $query->createNamedParameter('uid_owner'),
+                'item_type' => $query->createNamedParameter('item_type'),
+                'permissions' => $query->createNamedParameter(0),
+                'stime' => $query->createNamedParameter(0),
+                'accepted' => $query->createNamedParameter(0),
+                'mail_send' => $query->createNamedParameter(0),
+                'share_type' => $query->createNamedParameter(0),
+                'share_with' => $query->createNamedParameter($appId),
+                'attributes' => $query->createNamedParameter('[["permissions","before"]]'),
+            ])
+            ->executeStatement();
+
+        $query = $this->connection->getQueryBuilder();
+        $query->update('share')
+            ->set('attributes', $query->createNamedParameter('[["permissions","after"]]'));
+        if ($this->connection->getDatabaseProvider(true) === IDBConnection::PLATFORM_MYSQL) {
+            $query->where($query->expr()->eq('attributes', $query->createFunction("JSON_ARRAY(JSON_ARRAY('permissions','before'))"), IQueryBuilder::PARAM_JSON));
+        } else {
+            $query->where($query->expr()->eq('attributes', $query->createNamedParameter('[["permissions","before"]]'), IQueryBuilder::PARAM_JSON));
+        }
+        $query->executeStatement();
+
+        $query = $this->connection->getQueryBuilder();
+        $query->select('attributes')
+            ->from('share')
+            ->where($query->expr()->eq('share_with', $query->createNamedParameter($appId)));
+
+        $result = $query->executeQuery();
+        $entries = $result->fetchAll();
+        $result->closeCursor();
+        self::assertCount(1, $entries);
+        self::assertEquals([['permissions','after']], json_decode($entries[0]['attributes'], true));
+    }
+
+    public function testDateTimeEquals(): void {
+        $dateTime = new \DateTime('2023-01-01');
+        $insert = $this->connection->getQueryBuilder();
+        $insert->insert('testing')
+            ->values(['datetime' => $insert->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATETIME_MUTABLE)])
+            ->executeStatement();
+
+        $query = $this->connection->getQueryBuilder();
+        $result = $query->select('*')
+            ->from('testing')
+            ->where($query->expr()->eq('datetime', $query->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATETIME_MUTABLE)))
+            ->executeQuery();
+        $entries = $result->fetchAll();
+        $result->closeCursor();
+        self::assertCount(1, $entries);
+    }
+
+    public function testDateTimeLess(): void {
+        $dateTime = new \DateTime('2022-01-01');
+        $dateTimeCompare = new \DateTime('2022-01-02');
+        $insert = $this->connection->getQueryBuilder();
+        $insert->insert('testing')
+            ->values(['datetime' => $insert->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATETIME_MUTABLE)])
+            ->executeStatement();
+
+        $query = $this->connection->getQueryBuilder();
+        $result = $query->select('*')
+            ->from('testing')
+            ->where($query->expr()->lt('datetime', $query->createNamedParameter($dateTimeCompare, IQueryBuilder::PARAM_DATETIME_MUTABLE)))
+            ->executeQuery();
+        $entries = $result->fetchAll();
+        $result->closeCursor();
+        self::assertCount(1, $entries);
+    }
+
+    public function testDateTimeGreater(): void {
+        $dateTime = new \DateTime('2023-01-02');
+        $dateTimeCompare = new \DateTime('2023-01-01');
+        $insert = $this->connection->getQueryBuilder();
+        $insert->insert('testing')
+            ->values(['datetime' => $insert->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATETIME_MUTABLE)])
+            ->executeStatement();
+
+        $query = $this->connection->getQueryBuilder();
+        $result = $query->select('*')
+            ->from('testing')
+            ->where($query->expr()->gt('datetime', $query->createNamedParameter($dateTimeCompare, IQueryBuilder::PARAM_DATETIME_MUTABLE)))
+            ->executeQuery();
+        $entries = $result->fetchAll();
+        $result->closeCursor();
+        self::assertCount(1, $entries);
+    }
+
+    protected function createConfig($appId, $key, $value) {
+        $query = $this->connection->getQueryBuilder();
+        $query->insert('appconfig')
+            ->values([
+                'appid' => $query->createNamedParameter($appId),
+                'configkey' => $query->createNamedParameter((string)$key),
+                'configvalue' => $query->createNamedParameter((string)$value),
+            ])
+            ->executeStatement();
+    }
+
+    protected function prepareTestingTable(): void {
+        if ($this->schemaSetup) {
+            $this->connection->getQueryBuilder()->delete('testing')->executeStatement();
+        }
+
+        $prefix = Server::get(IConfig::class)->getSystemValueString('dbtableprefix', 'oc_');
+        $schema = $this->connection->createSchema();
+        try {
+            $schema->getTable($prefix . 'testing');
+            $this->connection->getQueryBuilder()->delete('testing')->executeStatement();
+        } catch (SchemaException $e) {
+            $this->schemaSetup = true;
+            $table = $schema->createTable($prefix . 'testing');
+            $table->addColumn('id', Types::BIGINT, [
+                'autoincrement' => true,
+                'notnull' => true,
+            ]);
+
+            $table->addColumn('datetime', Types::DATETIME, [
+                'notnull' => false,
+            ]);
+
+            $table->setPrimaryKey(['id']);
+            $this->connection->migrateToSchema($schema);
+        }
+    }
 }

Spacing +7 added lines, -7 removed lines

@@ -111,7 +111,7 @@ 
 			->set('configvalue',
 				$query->expr()->castColumn(
 					$query->createFunction(
-						'(' . $query->expr()->castColumn('configvalue', IQueryBuilder::PARAM_INT)
+						'('.$query->expr()->castColumn('configvalue', IQueryBuilder::PARAM_INT)
 						. ' + 1)'
 					), IQueryBuilder::PARAM_STR
 				)
@@ -147,7 +147,7 @@ 
 			$version = $result->fetchOne();
 			$result->closeCursor();
 			if (str_starts_with($version, '11.')) {
-				$this->markTestSkipped('JSON is not supported on Oracle 11, skipping until deprecation was clarified: ' . $version);
+				$this->markTestSkipped('JSON is not supported on Oracle 11, skipping until deprecation was clarified: '.$version);
 			}
 		}
 
@@ -187,7 +187,7 @@ 
 		$entries = $result->fetchAll();
 		$result->closeCursor();
 		self::assertCount(1, $entries);
-		self::assertEquals([['permissions','after']], json_decode($entries[0]['attributes'], true));
+		self::assertEquals([['permissions', 'after']], json_decode($entries[0]['attributes'], true));
 	}
 
 	public function testDateTimeEquals(): void {
@@ -248,8 +248,8 @@ 
 		$query->insert('appconfig')
 			->values([
 				'appid' => $query->createNamedParameter($appId),
-				'configkey' => $query->createNamedParameter((string)$key),
-				'configvalue' => $query->createNamedParameter((string)$value),
+				'configkey' => $query->createNamedParameter((string) $key),
+				'configvalue' => $query->createNamedParameter((string) $value),
 			])
 			->executeStatement();
 	}
@@ -262,11 +262,11 @@ 
 		$prefix = Server::get(IConfig::class)->getSystemValueString('dbtableprefix', 'oc_');
 		$schema = $this->connection->createSchema();
 		try {
-			$schema->getTable($prefix . 'testing');
+			$schema->getTable($prefix.'testing');
 			$this->connection->getQueryBuilder()->delete('testing')->executeStatement();
 		} catch (SchemaException $e) {
 			$this->schemaSetup = true;
-			$table = $schema->createTable($prefix . 'testing');
+			$table = $schema->createTable($prefix.'testing');
 			$table->addColumn('id', Types::BIGINT, [
 				'autoincrement' => true,
 				'notnull' => true,

core/Migrations/Version33000Date20251106131209.php

Indentation +16 added lines, -16 removed lines

@@ -17,23 +17,23 @@
 
 #[DataCleansing(table: 'share', description: 'Fix share download permissions')]
 class Version33000Date20251106131209 extends SimpleMigrationStep {
-	public function __construct(
-		private readonly IDBConnection $connection,
-	) {
-	}
+    public function __construct(
+        private readonly IDBConnection $connection,
+    ) {
+    }
 
-	public function preSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
-		$qb = $this->connection->getQueryBuilder();
-		$qb->update('share')
-			->set('attributes', $qb->createNamedParameter('[["permissions","download",true]]'))
-			->where($qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_CIRCLE, IQueryBuilder::PARAM_INT)));
+    public function preSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
+        $qb = $this->connection->getQueryBuilder();
+        $qb->update('share')
+            ->set('attributes', $qb->createNamedParameter('[["permissions","download",true]]'))
+            ->where($qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_CIRCLE, IQueryBuilder::PARAM_INT)));
 
-		if ($this->connection->getDatabaseProvider(true) === IDBConnection::PLATFORM_MYSQL) {
-			$qb->andWhere($qb->expr()->eq('attributes', $qb->createFunction("JSON_ARRAY(JSON_ARRAY('permissions','download',null))"), IQueryBuilder::PARAM_JSON));
-		} else {
-			$qb->andWhere($qb->expr()->eq('attributes', $qb->createNamedParameter('[["permissions","download",null]]'), IQueryBuilder::PARAM_JSON));
-		}
+        if ($this->connection->getDatabaseProvider(true) === IDBConnection::PLATFORM_MYSQL) {
+            $qb->andWhere($qb->expr()->eq('attributes', $qb->createFunction("JSON_ARRAY(JSON_ARRAY('permissions','download',null))"), IQueryBuilder::PARAM_JSON));
+        } else {
+            $qb->andWhere($qb->expr()->eq('attributes', $qb->createNamedParameter('[["permissions","download",null]]'), IQueryBuilder::PARAM_JSON));
+        }
 
-		$qb->executeStatement();
-	}
+        $qb->executeStatement();
+    }
 }