Support SQL Functions

[timvandam]

Is your feature request related to a problem? Please describe.
I want to use a trigger to manage my "UpdatedAt" columns. This trigger calls a SQL Function that updates this column to the current timestamp. Currently, pgtyped is unable to parse functions.

E.g.:

/* @name CreateUpdatedAtFunction */
CREATE FUNCTION UpdatedAt()
RETURNS TRIGGER AS $$
    BEGIN
        NEW.updatedAt = NOW();
        RETURN NEW;
    END;
$$ LANGUAGE plpgsql;

Yields

17 | /* @name CreateUpdatedAtFunction */
18 | CREATE FUNCTION UpdatedAt()
19 | RETURNS TRIGGER AS $$
20 |     BEGIN
21 |         NEW.updatedAt = NOW();
22 >         RETURN NEW;
23 |     END;
24 | $$ LANGUAGE plpgsql;
25 | 
26 | 
Errors:
- (22:8) Parse error: extraneous input 'RETURN' expecting {<EOF>, '/*'}

Describe the solution you'd like
Support for this. I think that in principle all this requires is skipping the code block (i.e. the part delimited by $$.

[timvandam]

Note that the $$ delimiters can also contain text. Any delimiter starting and ending with $ will do. E.g. $updated_at_trigger_fn$ <code here> $updated_at_trigger_fn$ works too

https://www.postgresqltutorial.com/postgresql-plpgsql/dollar-quoted-string-constants/