VALUES clause support

[v-byte-cpu]

Is your feature request related to a problem? Please describe.

Hi there! It looks like Jet doesn't support VALUES clause. My personal use case is batch update statements, for instance

UPDATE public.some_table
SET name = (d.v)::text
FROM (
         VALUES (1, 'name1'), (2, 'name2')
     ) AS d(id, v)
WHERE some_table.id = (d.id)::bigint;

or

WITH d(id, v) AS (VALUES (1, 'name1'), (2, 'name2'))
UPDATE public.some_table
SET name = (d.v)::text
FROM d where some_table.id = (d.id)::bigint;

Describe the solution you'd like

Public API support for VALUES clause.

[go-jet]

Hi @v-byte-cpu. VALUES is not supported currently. You can use this workaround for now.