DuckDBConnection = duckdb_connection

DuckDBConnectionError = object of CatchableError

DuckDBInstance = duckdb_database

DuckDBQueryError = object of CatchableError

DuckDBResult = tuple[columns: seq[string], ## A sequence of column names in the result set.
                     rows: seq[Row]]

DuckDBValue = object
  case kind*: DuckDBType
  of DUCKDB_TYPE_BOOLEAN:
    booleanValue*: bool
  of DUCKDB_TYPE_TINYINT:
    tinyIntValue*: int8
  of DUCKDB_TYPE_SMALLINT:
    smallIntValue*: int16
  of DUCKDB_TYPE_INTEGER:
    integerValue*: int32
  of DUCKDB_TYPE_BIGINT:
    bigIntValue*: int64
  of DUCKDB_TYPE_UTINYINT:
    uTinyIntValue*: uint8
  of DUCKDB_TYPE_USMALLINT:
    uSmallIntValue*: uint16
  of DUCKDB_TYPE_UINTEGER:
    uIntegerValue*: uint32
  of DUCKDB_TYPE_UBIGINT:
    uBigIntValue*: uint64
  of DUCKDB_TYPE_FLOAT:
    floatValue*: float32
  of DUCKDB_TYPE_DOUBLE:
    doubleValue*: float64
  of DUCKDB_TYPE_TIMESTAMP, DUCKDB_TYPE_DATE, DUCKDB_TYPE_TIME:
    dateValue*: string
  of DUCKDB_TYPE_INTERVAL:
    intervalValue*: string
  of DUCKDB_TYPE_HUGEINT:
    hugeIntValue*: BigInt
  of DUCKDB_TYPE_UHUGEINT:
    uHugeIntValue*: BigInt
  of DUCKDB_TYPE_VARCHAR, DUCKDB_TYPE_BLOB:
    stringValue*: string
  of DUCKDB_TYPE_DECIMAL:
    decimalValue*: string
  of DUCKDB_TYPE_ENUM:
    enumValue*: string
  of DUCKDB_TYPE_LIST, DUCKDB_TYPE_STRUCT, DUCKDB_TYPE_MAP:
    listValue*: seq[DuckDBValue]
  of DUCKDB_TYPE_ARRAY:
    arrayValue*: seq[DuckDBValue]
  of DUCKDB_TYPE_UUID:
    uuidValue*: string
  of DUCKDB_TYPE_UNION:
    unionValue*: seq[DuckDBValue]
  of DUCKDB_TYPE_BIT:
    bitValue*: seq[bool]
  of DUCKDB_TYPE_TIME_TZ, DUCKDB_TYPE_TIMESTAMP_TZ:
    timeValue*: string
  else:
    nil

Row = seq[DuckDBValue]

DuckDBError = -1

DuckDBSuccess = 0