not really since as you know there is always ObjectScript under most SQL Functions.
BUT as mentioned: I found TO_VECTOR()  the most comfortable one.
without SQL it might look like this:  or worse

;; assume a $LB structure of %Integer as input
set intlist=$LB(...........)
;; fill vector
set maxvecsize=22    ; just an assumption
 for i=1:1:maxvecsize {
  set val=$li(intlist,i)
  if '(val\1=val)  continue
  set $vector(vec,i,"int")=val
 }
write $isvector(vec)
write vec
zwrite vec

I think the difference is obvious.

Servus

Hallo @Ditmar Tybussek  lange nix mehr gehört von dir !

See my article Using VECTORs in ObjectScript.

related to your code: 
Simple Set vector=.... doesn't work
it is       Set $VECTOR(vectorname,  pos,type)   very clear example
and type can never be changed 
position is less sensitive. 

In your case using SQL functíon TO_VECTOR() might be quite comfortable
as it does all the checks for you under cover.
i also used all-MiniLM-L6-v2 (as PY method) starting from  label sc3 in the example
in my OEX package Vector-inside-IRIS

LG. aus Wien

 

THe 3rd AI proposal looked better -  Just looked!

• it refers to an Java based installation for DBeaver.  (ok for this)
• the fact that Apache Superset  is straight and only Py based was totally ignored

so the advice was useless!  

a personal hint:

• be as precise in your question as possible.

example (with shortened replies)
- how to run IRIS ODBC client install in a fresh container ?   >> use IRIS container as base  😕
- how to run IRIS ODBC client install in a NOT IRIS based container ? >> No idea, ask developer community 🤒
- how to connect to Cloud SQL from Apache Superset osing ODBC and TLS/SSL ?
>>> what I really has in mind.  (found it by accident)  
Reply is quite detailed It's the example from the announcement above  I'll try

minor simplification:
inserting my 77 char server address into the15 char Server-IP of Windows DSN caused me repeating problems.
k8s-45090081-a9b5a485-233c4dadf5-46cc35674de4c26d.elb.us-east-1.amazonaws.com

A real pain to verify
So I translated it to a real IP address using nslookup

SAMPLES>$nslookup k8s-45090081-a9b5a485-233c4dadf5-46cc35674de4c26d.elb.us-east-1.amazonaws.com
;  . . . .
Name:    k8s-45090081-a9b5a485-233c4dadf5-46cc35674de4c26d.elb.us-east-1.amazonaws.com
Address:  3.215.248.100

3.215.248.100
was working excellent and easy to check and to work with
 

see: https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=RGOT_complete

browser search "Extent Index"

$ZTRAP is pretty much the same idea as ONERROR that you find in
BASIC, VB, VBA, JavaScript  and some other old languages.  
a left over from M
 

in docker-compose.yml

change

command: --key /dur/key/iris.key

to

command: --key /dur/key/iris.key -b "sleep 2000" 

so the container starts but IRIS is not started
2000 is just some hang for your investigation (2000 sec)

in a 2nd session run

docker-compose exec iris bash

and start IRIS manually to see all details of what might be wrong
 

I share your suspicion on reserved Verbs.

You may try 

m.Name as "myName"

Or even

m.Name as "Name"

Just a guess from the  hip

first you need to install a valid DSN: Defining an ODBC Data Source on Windows
for PS you may take the same approach as described here

Wrap your SELECT in an Outer  SELECT LIST(...inner select ...)
try:

SELECT LIST(DIAGNOSE) FROM (
 SELECT MRDIA_.....->MRCID....
 FROM ......
 WHERE .....
 ORDER BY ......
)

What you describe is indeed named Global:
and the syntax could be  ^ehr.IP to follow your question.
It is visible over the whole namespace.
If you use ^%ehr.IP the % makes it available over all namespaces of your installation.

Set ^%ehr.IP="whatever you need" is creating it   
 

@Enrico Parisi :  I fully support your point!
Global mapping - in any form - is the path for CONTROLLED managed growth.
So I wonder about the intention of the "continuation". 

A quite interesting feature.
Did you take a look on how backup management is affected / involved by this design ? 
I just fail to imagine how to keep all this in synch.
e.g. if spread over several drives:
Are they backed up in total or in volume junks ?