25.5. Using duckdb.query() #
The duckdb.query() function is an advanced feature that is not required for most queries. You must only use it to run a query that uses the DuckDB-specific syntax that is not valid in Postgres Pro.
Example 25.5.
-- 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; $$);