fix(DONT MERGE): duckdb>=1.4.1 typing & warnings - #3189

from __future__ import annotations

import datetime as dt  # noqa: F811
import decimal
import uuid
from typing import Any, Callable, cast  # noqa: F811

import duckdb  # noqa: F811
import numpy as np  # noqa: F811
import pandas as pd

lit = cast("Callable[[Any], duckdb.Expression]", duckdb.ConstantExpression)


def try_lit(*inputs: Any) -> None:
    for value in inputs:
        print(f"{value}: {lit(value)}")


try_lit(
    None,
    pd.NaT,
    pd.NA,
    np.ma.masked,
    True,
    False,
    0,
    -999_991,
    100_000_000_000_000,
    1e98,
    decimal.Decimal("2933.957546"),
    uuid.uuid5(uuid.NAMESPACE_URL, "hello"),
    dt.datetime(2034, 1, 23, 4, 2, 56),
    dt.time(1, 2, 3, 4),
    dt.date(1023, 3, 1),
    dt.timedelta(50),
    "i am a string",
    bytearray(range(4)),
    memoryview(b"i was a bytestring"),
    b"i am a bytestring",
    ["list", "of", "str"],
    ("tuple", "of", "str"),
    {"dict": "str"},
    np.arange(10),
    np.datetime64(dt.date(2000, 3, 1)),
    duckdb.UnsignedIntegerValue(50),
)

None: NULL
NaT: NULL
<NA>: NULL
--: NULL
True: true
False: false
0: 0
-999991: -999991
100000000000000: 100000000000000
1e+98: 1e+98
2933.957546: 2933.957546
074171de-bc84-5ea4-b636-1135477620e1: '074171de-bc84-5ea4-b636-1135477620e1'::UUID
2034-01-23 04:02:56: '2034-01-23 04:02:56'::TIMESTAMP
01:02:03.000004: '01:02:03.000004'::TIME
1023-03-01: '1023-03-01'::DATE
50 days, 0:00:00: '50 days'::INTERVAL
i am a string: 'i am a string'
bytearray(b'\x00\x01\x02\x03'): '\x00\x01\x02\x03'::BLOB
<memory at 0x00000154FFEA3100>: 'i was a bytestring'::BLOB
b'i am a bytestring': 'i am a bytestring'::BLOB
['list', 'of', 'str']: ['list', 'of', 'str']
('tuple', 'of', 'str'): ['tuple', 'of', 'str']
{'dict': 'str'}: {'dict': 'str'}
[0 1 2 3 4 5 6 7 8 9]: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9]
2000-03-01: '2000-03-01'::DATE
50: 50