yiisoft/yii2 · error · yii\base\InvalidArgumentException

To use Expression in from() method, pass it in array format

Error message

To use Expression in from() method, pass it in array format with alias.

What it means

Error "To use Expression in from() method, pass it in array format with alias." thrown in yiisoft/yii2.

Source

Thrown at framework/db/Query.php:591

)
)?
\s*
$
~iux
PATTERN;
                if (preg_match($pattern, $tableName, $matches)) {
                    if (isset($matches[2])) {
                        list(, $tableName, $alias) = $matches;
                    } else {
                        $tableName = $alias = $matches[1];
                    }
                }
            }


            if ($tableName instanceof Expression) {
                if (!is_string($alias)) {
                    throw new InvalidArgumentException('To use Expression in from() method, pass it in array format with alias.');
                }
                $cleanedUpTableNames[$this->ensureNameQuoted($alias)] = $tableName;
            } elseif ($tableName instanceof self) {
                $cleanedUpTableNames[$this->ensureNameQuoted($alias)] = $tableName;
            } else {
                $cleanedUpTableNames[$this->ensureNameQuoted($alias)] = $this->ensureNameQuoted($tableName);
            }
        }

        return $cleanedUpTableNames;
    }

    /**
     * Ensures name is wrapped with {{ and }}
     * @param string $name
     * @return string
     */
    private function ensureNameQuoted($name)

View on GitHub (pinned to 66f00d18a2)

When it happens

Trigger: Thrown at framework/db/Query.php:591 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of yiisoft/yii2@66f00d18a2 (2026-08-17). Data as JSON: /api/errors/7643407adda49e08. Report an issue: GitHub.