Missing support of interval types

[Pavel-Strybuk]

Describe the bug

Missing support of interval types:

• IntervalNanosecond
• IntervalMicrosecond
• IntervalMillisecond
• IntervalSecond
• IntervalMinute
• IntervalHour
• IntervalDay
• IntervalWeek
• IntervalMonth
• IntervalQuarter
• IntervalYear

https://clickhouse.com/docs/en/sql-reference/data-types/special-data-types/interval

Steps to reproduce

1. Execute select interval 30 day or other supported units (seconds, years, ..., see link above)

Expected behaviour

No errors

clickhouse-connect and/or ClickHouse server logs

ERROR:clickhouse_connect.datatypes.registry: -- [27/Aug/2024 13:16:44] - Unrecognized ClickHouse type base: IntervalDay name: IntervalDay

Configuration

Environment

• clickhouse-connect version: 0.7.16
• Python version: 3.11.9
• Operating system: Fedora 40

ClickHouse server

• ClickHouse Server version: 23.12.2.59