sqlGetFromDca

The sqlGetFromDca hook is triggered when sql definitions in DCA files are evaluated. It passes the generated SQL definition and expects the same as return value.

Parameters

  1. array $sql

    The parsed SQL definition.

Return Values

Return $sql after adding your custom definitions.

Example

// src/EventListener/SqlGetFromDcaListener.php
namespace App\EventListener;

use Contao\CoreBundle\DependencyInjection\Attribute\AsHook;

#[AsHook('sqlGetFromDca')]
class SqlGetFromDcaListener
{
    public function __invoke(array $sql): array
    {
        // Modify the array of SQL statements

        return $sql;
    }
}

References