join() documentation incomplete on page 'Python Client API'

[Dutcho]

The join() documentation states “Types supported are 'inner' and 'left'”. However, more types are supported, as shown in the error message for below snippet:

>>> duckdb.values((1, 2)).join(duckdb.values((1, 3)).set_alias('right'), 'col0', 'xxx').show()
Traceback (most recent call last):
...
duckdb.duckdb.InvalidInputException: Invalid Input Error: Unsupported join type xxx, try one of: 'left', 'right', 'outer', 'semi', 'inner', 'anti'

Page URL: https://duckdb.org/docs/api/python/reference/