This documentation shows the absolute basics of the API, and then a bunch about integrating with various libraries. It does not show how to query or execute (different calling conventions!) using parameters.
Page URL: https://duckdb.org/docs/stable/guides/python/execute_sql.html