MERGE INTO command not supported?

[psteinroe]

Discussed in #548

^{Originally posted by jonatanschroeder October 8, 2025}
Hi, I'm having issues where the MERGE INTO command causes syntax errors on VSCode, even though the command in use is supported by Postgres itself. A command like the following:

MERGE INTO course_permissions AS cp
USING (SELECT 1 AS user_id, 2 AS course_id, 'Owner'::enum_course_role AS course_role) AS data
ON (cp.course_id = data.course_id AND cp.user_id = data.user_id)
WHEN MATCHED THEN UPDATE SET course_role = data.course_role
WHEN NOT MATCHED THEN
INSERT
  (user_id, course_id, course_role)
VALUES
  (data.user_id, data.course_id, data.course_role);

works on Postgres, but causes an issue on VSCode using the supabase.postgrestools extension:

Could you confirm if this is a bug with either the extension, the binary, or a related library?