create table public.t1 (
    id bigint primary key,
    value text
);

create materialized view public.mv1 as
with sub as changelog from public.t1
select
    *
from sub;

[2024-09-27 17:07:06] [XX000] ERROR: Failed to prepare the statement
[2024-09-27 17:07:06] Caused by:
[2024-09-27 17:07:06] sql parser error: expected SELECT, VALUES, or a subquery in the query body, found: .
[2024-09-27 17:07:06] LINE 2: with sub as changelog from public.t1
[2024-09-27 17:07:06] ^

create materialized view public.mv1 as
with sub as changelog from t1
select
    *
from sub;