Add support for 23ai Vector data type
Quick SQL does not support the Vector even when compatibility is set to 23ai.
Please add support for this data type
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) );
Yes! That is a must going forward.