MERGE INTO command not supported?

[jonatanschroeder]

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?

[psteinroe]

that's a bug with our statement splitter - thanks for reporting! It's a simple fix, but i am ooo until Sunday. Maybe @juleswritescode can do it, otherwise I will latest monday :)

[psteinroe]

fix is up in #550 :)