Just an update: Postgres support almost works now. I have some issues determining the correct data type of the returned values, but once that is resolved it's time to work on the 2D array arguments.
I've changed SQL[1] (connect) to accept a left argument, being the database type. I will also make it register mnemonic functions so that you don't have to see the function numbers. Thus, once the 2D stuff is ready you'll be able to copy the content of "foo" in an SQLite database into table "bar" in a Postgres database like this:
'libsql' ⎕FX 'SQL'
dbA ← 'sqlite' SQL∆Connect '/path/to/database'
result ← 'select * from foo' SQL∆Select[dbA] ⍬
'insert into bar (a,b) values (?,?)' SQL∆Exec[dbB] result
SQL∆Close dbA
SQL∆Close dbB
Are you all OK with this syntax?
Regards,
Elias