describe on an ARRAY or OBJECT column incorrectly returns VARIANT

[tekumara]

result metadata for an ARRAY or OBJECT column incorrectly returns a type_code of 5 (VARIANT) but should be:

• 9 for OBJECT
• 10 for ARRAY

as per https://docs.snowflake.com/en/user-guide/python-connector-api.html#type-codes

[tekumara]

solving this will require new duckdb logical types that work as json.

json itself is a logical type of varchar, so these new types should map to varchar. The new types will be treated a varchar by the json functions.