PostgreSql Dialect - Support for CREATE OR REPLACE TRIGGER

[griffio]

SQLDelight Version

2.0.x

SQLDelight Dialect

PostgreSql

Describe the Bug

Add better support for PostgreSql triggers - include execute function/procedure

It may be only existing functions/procedures can be called as CREATE FUNCTION is not likely to be supported in SqlDelight - there is a subset for trigger functions https://www.postgresql.org/docs/current/plpgsql-trigger.html

Extracted from this request for CREATE FUNCTION #4795

https://www.postgresql.org/docs/current/sql-createtrigger.html

CREATE [ OR REPLACE ] [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] }
    ON table_name
    [ FROM referenced_table_name ]
    [ NOT DEFERRABLE | [ DEFERRABLE ] [ INITIALLY IMMEDIATE | INITIALLY DEFERRED ] ]
    [ REFERENCING { { OLD | NEW } TABLE [ AS ] transition_relation_name } [ ... ] ]
    [ FOR [ EACH ] { ROW | STATEMENT } ]
    [ WHEN ( condition ) ]
    EXECUTE { FUNCTION | PROCEDURE } function_name ( arguments )

where event can be one of:

    INSERT
    UPDATE [ OF column_name [, ... ] ]
    DELETE
    TRUNCATE

The sql-psi grammar would have to be replaced in the postgresql.bnf

https://github.com/AlecKazakova/sql-psi/blob/fb53ff362381020388407bed11189b89bfe9bf1b/core/src/main/kotlin/com/alecstrong/sql/psi/core/sql.bnf#L134-L139

Stacktrace

No response