Sergei Tigrov

Process expressions inside param values when build a query

2

* Allows non-unique param names inside `Expression::$params` (they will be replaced with unique names) * Process `Expression` instances inside `Expression::$params` ### Related PRs * https://github.com/yiisoft/db-sqlite/pull/289 * https://github.com/yiisoft/db-mysql/pull/321 * https://github.com/yiisoft/db-pgsql/pull/336 *...

Allow scalar values for `Query::select()`

1

### Related PRs * yiisoft/db-pgsql#340 * yiisoft/db-sqlite#292 * yiisoft/db-oracle#259 * yiisoft/db-mssql#296 * yiisoft/db-mysql#329 | Q | A | ------------- | --- | Is bugfix? | ❌ | New feature? |...

Refactor `Query::column()`

1

Improve performance | Q | A | ------------- | --- | Is bugfix? | ❌ | New feature? | ❌ | Breaks BC? | ❌ | Fixed issues | -

* `DbArrayHelper::getColumn()` should be replaced with `array_column()` * `DbArrayHelper::getValueByPath()` is not suitable for db fields and shold be removed E.g. `$key` can be `table_name.column` what will be result of an...

Allow scalars `int|float|bool` in `Query::select()`

1

For some cases a query like `SELECT 1 FROM ...` required. If allow scalars `int|float|bool` for columns in `Query::select()` method, the result could be `$query->select(1)` => `SELECT 1 FROM ...`...

The method should return all types defined by user. `public function getUserDefinedTypes(string $schemaName = '', bool $refresh = false): array;`

New columns for v2

2

This is a draft to see new concept of columns for version 2.0 Main changes: 1. Removed `ColumnSchema::$name` and `ColumnSchema::$precision` (use `ColumnSchema::$size`) 2. Renames `ColumnSchema::$enumValues` to `ColumnSchema::$values` (related with some...

* Remove `AbstractDMLQueryBuilder::getTypecastValue()` method * Remove `string $table` argument from `AbstractDMLQueryBuilder::normalizeColumnNames()` and `AbstractDMLQueryBuilder::getNormalizeColumnNames()` * Remove `SchemaInterface::TYPE_JSONB` constant * Remove `TableSchemaInterface::compositeForeignKey()` method * Remove argument `bool $withColumn = false` from `Quoter::getTableNameParts()`...

There are two problems when update table using expressions: 1. `Expression::$params` are not passed in the query. 2. If `Expression::$params` have an `ExpressionInterface` inside, it is not processed ```php $values...

Unique indexes can be loaded in 3 different ways

1

Unique indexes can be loaded in 3 different ways: * `Schema::loadTableConstraints(): Constraint[]`