Client APIs
Converting from Other Types
To make the API as easy to use as possible, we have added implicit conversions from existing type objects to a DuckDBPyType instance.
This means that wherever a DuckDBPyType object is expected, it is also possible to provide any of the options listed below.  
#### Python Built-ins {#docs:api:python:types::python-built-ins}  
The table below shows the mapping of Python Built-in types to DuckDB type.  
<div class="narrow_table monospace_table"></div>  
| Built-in types | DuckDB type |
|:---------------|:------------|
| bool           | BOOLEAN     |
| bytearray      | BLOB        |
| bytes          | BLOB        |
| float          | DOUBLE      |
| int            | BIGINT      |
| str            | VARCHAR     |  
#### Numpy DTypes {#docs:api:python:types::numpy-dtypes}  
The table below shows the mapping of Numpy DType to DuckDB type.  
<div class="narrow_table monospace_table"></div>  
| Type        | DuckDB type |
|:------------|:------------|
| bool        | BOOLEAN     |
| float32     | FLOAT       |
| float64     | DOUBLE      |
| int16       | SMALLINT    |
| int32       | INTEGER     |
| int64       | BIGINT      |
| int8        | TINYINT     |
| uint16      | USMALLINT   |
| uint32      | UINTEGER    |
| uint64      | UBIGINT     |
| uint8       | UTINYINT    |  
#### Nested Types {#docs:api:python:types::nested-types}