Pull Request Checklist

Please make sure to review and check all of these items:

• Have you added new tests to prevent regressions?
• Does yarn test or yarn test-DIALECT pass with this change (including linting)?
• Is a documentation update included (if this change modifies existing APIs, or introduces new ones)?
• Did you update the typescript typings accordingly (if applicable)?
• Does the description below contain a link to an existing issue (Closes #[issue]) or a description of the issue you are solving?
• Did you follow the commit message conventions explained in CONTRIBUTING.md?

Description Of Change

Closes #14517
Other bug report: #14472 (comment)

This PR fixes the replacement parser to replace them in the following two queries:

-- replacements were not transformed in arrays
SELECT * FROM users WHERE id = ARRAY[:id]::int[];
SELECT * FROM users WHERE id = ARRAY[?]::int[];

-- replacements were not transformed if followed by ';'
SELECT * FROM users WHERE id = :id;
SELECT * FROM users WHERE id = ?;