function duckdbTypeToEvidenceType(column_type) {
	// objects aren't handled well
	if (isObjectType(column_type)) return 'string';
	if (isDecimalType(column_type)) return 'number';

	switch (column_type) {
		case 'BOOLEAN':
			return 'boolean';
		case 'BIGINT':
		case 'DOUBLE':
		case 'FLOAT':
		case 'INTEGER':
		case 'SMALLINT':
		case 'TINYINT':
		case 'UBIGINT':
		case 'UINTEGER':
		case 'USMALLINT':
		case 'UTINYINT':
		case 'HUGEINT':
			return 'number';
		case 'UUID':
		case 'VARCHAR':
			return 'string';
		case 'DATE':
		case 'TIMESTAMP':
		case 'TIMESTAMP_S':
		case 'TIMESTAMP_MS':
		case 'TIMESTAMP_NS':
		case 'TIMESTAMP WITH TIME ZONE':
			return 'date';

		// the badlands
		// we should probably convert these in the client library too
		case 'INTERVAL': // return 'Uint32Array';
		case 'TIME':
		case 'TIME WITH TIME ZONE': // return 'bigint';
		case 'BLOB':
		case 'JSON':
		case 'BIT': // return 'Uint8Array';
			return 'string';
		default:
			// column_type should be `never`
			console.error(`Column type ${column_type} is not supported`);
			return 'string';
	}
}
@param {string} column_type
@returns {'number' | 'boolean' | 'string' | 'date'}