Error: INTERNAL Error: Unsupported logical type for RemoveAlias

[alitrack]

What happens?

a column is json, when write to postgres with the help of postgres_scanner, got

Error: INTERNAL Error: Unsupported logical type for RemoveAlias

To Reproduce

create table tbl as 
SELECT json_extract(hourly, '$.temperature_2m[1]') as temp
from read_json('https://api.open-meteo.com/v1/forecast?latitude=-33.8678&longitude=151.2073&hourly=temperature_2m&forecast_days=1', auto_detect=true, format='newline_delimited');

create table  db.abc as select * from tbl;

OS:

macOS

PostgreSQL Version:

14.10

DuckDB Version:

0.9.2

DuckDB Client:

duckdb cli

Full Name:

Steven Lee

Affiliation:

alitrack.com

Have you tried this on the latest main branch?

• [X] I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• [X] I agree