Add support for 23ai Vector data type

[SyNuOra]

Quick SQL does not support the Vector even when compatibility is set to 23ai.

Please add support for this data type

[BarryB0001]

Plus one. I'm guessing this would be really easy to do.

Use Case
I am using vectors quite a bit, wanting to make tables with vector columns, but I don't think Quick SQL supports it. So I have to create my column with the wrong data type and use a script to change it afterwards.

data_feed_vectors
CHUNK_POS num
CHUNK_SIZE num
CHUNK_TEXT vc4000
EMBED_VECTOR vector8200

create table data_feed_vectors (
id number generated by default on null as identity
constraint fac_commc_data_feed_vectors_id_pk primary key,
CHUNK_POS number,
CHUNK_SIZE number,
CHUNK_TEXT varchar2(4000 char),
EMBED_VECTOR vector(8200)
);

[pallasinfotech]

Yes! That is a must going forward.