for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
declare(strict_types=1);
namespace Yiisoft\Db\Tests\Provider;
use Yiisoft\Db\Expression\Expression;
final class QueryBuilderProvider
{
public function buildFrom(): array
return [
[
'table1',
<<<SQL
SELECT * FROM table1
SQL,
],
['table1'],
new Expression('table2'),
SELECT * FROM table2
[new Expression('table2')],
['alias' => 'table3'],
SELECT * FROM table3 alias
['alias' => new Expression('table4')],
SELECT * FROM table4 alias
['alias' => new Expression('func(:param1, :param2)', ['param1' => 'A', 'param2' => 'B'])],
SELECT * FROM func(:param1, :param2) alias
['param1' => 'A', 'param2' => 'B'],
];
}