For testing I'd suggest to try an IRIS Community version 
Latest IRIS 2024.1 runs fine on Win11
the testing effort for that archaic code would be the same either for IRIS or latest Caché
the gap to bridge is about 2 decades in any case 

set var="MyClass"
execute "set obj=##class("_var_").%New()"

a bit dirty but matches your request

BTW:  from bash inside the container run

/iris-main -h

to see all available options
 

in docker-compose.yml  set
 

  command: -b "sleep 1d" 

• then you have a full day to access your container
• start IRIS manually  from bash as you need it

CONGRATULATIONS  to the Winners !

thx. fixed

 Guessing after the rater unclear description you are looking for Implicit Join

->  mimic an arrow in plain ASCII  does that

SELECT MySetting -> Name  from MyObj

It acts as LEFT OUTER JOIN 
https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=GSQL_implicitjoins   
https://docs.intersystems.com/iris20241/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_join

Alternate approach:
in SMP SQL  run this:
 

CREATE PROCEDURE ZPM.terminal() LANGUAGE OBJECTSCRIPT
{
 zpm "install webterminal"
 quit 1
}

 and next
 SELECT ZPM.terminal()

the final slash after terminal is important   !

 http://localhost:52773/terminal/

you can verify the installation in SMP  System > Security Management > Web Applications

agreed.
But Switching on/off Journal by process every time you write ^EVENT seems rather uncomfortable.

though it's compact as you know exactly when you need it,
 

depending on the actual long time use you may of course also    
use ^mtemp.EVENT  (in IRISTEMP)    
instead of a journaled ^EVENT in your actual namespace to escape transactions

• LOCK would be indeed the best equivalent to Isolation Modes
• just IRISTEMP doesn't react to COMMIT or ROLLBACK  (there is no related Journal)
• so instead of writing to your ^EVENT Global you may write to a PPG ^||EVENT acting as your  private temp
• after Commit or Rollback you decide if you MERGE  ^||EVENT to public ^EVENT or not.
• from your description, I assume you do it anyhow  

did you check TIMESTAMPDIFF ??

there is an example in OEX 
https://openexchange.intersystems.com/package/db-migration-using-SQLgateway

It's for PostgreSQL but the difference is only the specific jdbc used

Congratulations to all the winners!
It was a great event and highly useful to follow.

PLEASE!
if you have a different question then PLEASE don't change the original content
this breaks the total information flow.
Existing replies will look like nonsense!

Thanks @Raj Singh  great input  !
I recently struggled with LOAD DATA and finally dropped it in favor
of an old-fashioned COS import for 2 reasons:

• installation of Java was a prerequisite (might be mentioned somewhere, not identified) not a default in community containers
• quality of data was POOR to express it politely e.g:
  • column expected to be DOUBLE   >> content was 
    • number 
    • $ number
    • some text
    • NULL
• date with any sick non -SQL format
• just empty lines by wild running \n

so some exception handling after validation would have been a great feature in my case
to filter out sick records.

The sick CSV is available on GitHub
 
 

By SQL priniciple:     
any straight name is meant to be a COLUMN of the actual table.  eg. Embeddings
but an external HostVariable is designated by an initial : (colon)  e.g.  : new_embedding_str or :params

This seems to be the deeper cause your problem

in addition I'd suggest to add  print(new_embedding_str)  to verify its format. (one of my problems.

Furthermore, take a closer look to this example:
iris-vector-search/blob/main/demo/sql_demo.ipynb