The duckdb.query() function is an advanced feature that is not required for most analytical queries. You must only use it to run a query that uses the DuckDB-specific syntax that is not valid in Postgres Pro.

-- This query uses DuckDB's PIVOT syntax, so it must be wrapped in duckdb.query()
SELECT * FROM duckdb.query($$
  PIVOT sales_summary
  ON product_category
  USING SUM(total_sales)
  GROUP BY region;
$$);