Views referencing JSON fields in PostgreSQL JSON(B) columns don't show values for them

[curio77]

What happens?

When I execute a SELECT statement on a PostgreSQL table with a JSONB-type column that includes an output column for a field in that column (extracted via a JSONPath expression), that column yields data as expected. If I create a view for the same statement, the column remains empty.

To Reproduce

SELECT id, json_col->'$.some_field' some_field FROM my_psql_table;
-- result contains values in some_field column ✓
CREATE VIEW my_view AS SELECT id, json_col->'$.some_field' some_field FROM my_psql_table;
FROM my_view;
-- result DOES NOT contain values in some_field column 

OS:

Linux

PostgreSQL Version:

16.4

DuckDB Version:

1.1.0

DuckDB Client:

CLI

Full Name:

Marco Götze

Affiliation:

(none)

Have you tried this on the latest main branch?

• 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?

• I agree