Contao Summit 2026 in Leipzig 15th and 16th October

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