[FR] - enhance clickhouse type support

[modelorona]

Should support

Type	Category	Notes
BFloat16	Float	ML floating-point. Add to FloatTypes + AliasMap.
Time	Temporal	Time-of-day. Range: -999:59:59 to 999:59:59.
Time64	Temporal	High-precision Time variant.
LineString	Geo	No scanner or type classification.
MultiLineString	Geo	Same as LineString.
Ring	Geo	Has scanner but missing from GeometryTypes.
Geometry	Geo	ClickHouse's union over Point/Ring/Polygon/etc. No scanner.
AggregateFunction(fn, T...)	Aggregate	Appears in materialized views. Needs scanner to avoid crash on browse.
SimpleAggregateFunction(fn, T...)	Aggregate	Same as AggregateFunction.

Lower priority

Type	Category	Notes
Variant(T1, T2, ...)	Compound	Union type. Needs design work for scanning/formatting.
Dynamic	Compound	Polymorphic column. Same as Variant.
QBit(T, N)	Vector	Vector storage for similarity search. Wait for user demand.

[dhimanAbhi]

Hi @modelorona , I would like to work on this feature, could you please assign this to me?
Also, I would like to join clidey community's discord or any other communication channel for discussions!

Thanks!

[modelorona]

Hi @dhimanAbhi , thanks for your interest! We've got a Discord (which I see you're already in) so feel free to reach out there.

Let me know how you plan to go about these changes

[modelorona]

hey @dhimanAbhi is this something you're still working on?

[dhimanAbhi]

Hi @modelorona , thanks for reaching out.
Yes, I am actively working on it , I have though added the support. I encountered bugs and issues while testing to retrieve data from certain ClickHouse data types in whodb. I will get back to you positively tomorrow and update you with the progress.

PS: I love the project and would be seeing some more open issues after this 😄
Thank You!