pg_duckdb create.sql query fails due to outdated syntax in pg_duckdb 0.3.0

[saurabhojha]

This command in pg_duckdb/benchmark.sh pulls the docker image with the latest version of duck db extension (0.3.0).

sudo docker run -d --name pgduck -p 5432:5432 -e POSTGRES_PASSWORD=duckdb -v ./hits.parquet:/tmp/hits.parquet pgduckdb/pgduckdb:16-main

The create query subsequently fails with the following error:

psql postgres://postgres:duckdb@localhost:5432/postgres -f create.sql

psql:/tmp/create.sql:3: ERROR:  a column definition list is only allowed for functions returning "record"
LINE 3: from read_parquet('/tmp/hits.parquet') as (WatchID BIGINT, J...
                                                   ^
HINT:  If you use DuckDB functions like read_parquet, you need to use the r['colname'] syntax introduced in pg_duckdb 0.3.0. It seems like you might be using the outdated "AS (colname coltype, ...)" syntax

[saurabhojha]

Created a pr to fix the issue: #307